Solved

Can't create database on cluster from remote server

Posted on 2012-03-16
4
1,474 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 50

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 50

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard 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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

710 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