Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1529
  • Last Modified:

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?
0
bergquistcompany
Asked:
bergquistcompany
  • 2
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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".
0
 
bergquistcompanyAuthor Commented:
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.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Maybe you need to give permissions to SQL Server user to create files in system folders.
0
 
bergquistcompanyAuthor Commented:
That was it!  Thanks!
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now