Solved

SQL can't create files on drive d or e

Posted on 2011-02-22
4
1,429 Views
Last Modified: 2012-06-27
Hello,

When trying to create a database on our new SQL server ( with drive d set for data and e for log files ) I get the following message:

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'D:\SQLDatabases\test.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5123)

Outside of SQL we can create files in the relevant folders. It makes no difference if I login using windows or SQL authentication.  Also when trying to restore files from d or e SQL does not show the files in the browse window.

Thanks




0
Comment
Question by:Petermcg001
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34950039
if this is a cluster node, D: and E: must be on the same cluster resource ..
if not, still, D: and E: must not be mapped (network) drives.

please clarify
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 34950056
>> Outside of SQL we can create files in the relevant folders. It makes no difference if I login using windows or SQL authentication.

Check whether the startup account of SQL Server has permissions on D: drive in order to create database with files on D: drive..
Also check whether it is a mapped network drive as mentioned above..
0
 
LVL 1

Author Comment

by:Petermcg001
ID: 34950088
Hi,

It was the account issue, it had been set to use the network service.  I changed it to local system and it's fine now.

It's interesting that the account had access to c but not d or e.

Thanks for your help.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34950246
Welcome..
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

Suggested Solutions

Title # Comments Views Activity
Log Backup 2 21
Script to randomly create characters in MS SQL 6 30
Square brackets 4 37
Parsing out characters on the right side of hyphen 3 23
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.
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

943 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

15 Experts available now in Live!

Get 1:1 Help Now