Solved

Can't create database on cluster from remote server

Posted on 2012-03-16
4
1,448 Views
Last Modified: 2012-03-19
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
Comment
Question by:bergquistcompany
  • 2
  • 2
4 Comments
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 37737019
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
 

Author Comment

by:bergquistcompany
ID: 37737844
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
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 37738232
Maybe you need to give permissions to SQL Server user to create files in system folders.
0
 

Author Closing Comment

by:bergquistcompany
ID: 37738877
That was it!  Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now