asked on
Can't create database on cluster from remote server
We have 2 different Windows 2008 that we are trying to install different applications on which require a SQL connection for creating a database, but neither work. The SQL Server is 2008 running SQL 2005.
One instance was installing Veeam and it failed to connect to the SQL database with error: "Error 27552: Error Creating database VeeamBackup. Server: Microsoft SQL Server BQSQL. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802). The work around was creating a local SQL Express database and then copying it to the SQL server and connecting it so the accounts are valid.
On another server we are trying a completely different application install and when we attempt to create a database I get "SQL Server Verification: Connect_Error"
The account I am using has all of the possible permissions assigned to it so I'm wondering if it's becasue I'm using the cluster name/ip to create the database that it isn't letting me.
I have 2 servers (SQL1 and SQL2 with SQLCluster as the instance name for the cluster and all with it's own IP). Please help?
One instance was installing Veeam and it failed to connect to the SQL database with error: "Error 27552: Error Creating database VeeamBackup. Server: Microsoft SQL Server BQSQL. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802). The work around was creating a local SQL Express database and then copying it to the SQL server and connecting it so the accounts are valid.
On another server we are trying a completely different application install and when we attempt to create a database I get "SQL Server Verification: Connect_Error"
The account I am using has all of the possible permissions assigned to it so I'm wondering if it's becasue I'm using the cluster name/ip to create the database that it isn't letting me.
I have 2 servers (SQL1 and SQL2 with SQLCluster as the instance name for the cluster and all with it's own IP). Please help?
Microsoft SQL Server 2005
Last Comment
bergquistcompany
How many times you tried to create the database. Seems to me that the database already exists, that's why giving the error "Some file names listed could not be created".
ASKER
No the database name doesn't exist. I actually called Veeam support and after trying several different names come to find they had to install SQL Express then migrate the database over and connect to it. It is just that we cannot create a database on the cluster. I had another server that needed to connect to SQL for a new app install and ran into the same issue, slightly different error "SQL Server Verification: Connect_Error" and it too cannot create a database on the cluster.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That was it! Thanks!