Can't create database on cluster from remote server
Posted on 2012-03-16
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?