Can't create database on cluster from remote server

Posted on 2012-03-16
Medium Priority
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?
Question by:bergquistcompany
  • 2
  • 2
LVL 54

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".

Author Comment

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.
LVL 54

Accepted Solution

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.

Author Closing Comment

ID: 37738877
That was it!  Thanks!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

587 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