Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Can't create database on cluster from remote server

Posted on 2012-03-16
4
Medium Priority
?
1,501 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 52

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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

688 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