Solved

SQL can't create files on drive d or e

Posted on 2011-02-22
4
1,434 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
[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
4 Comments
 
LVL 143

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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