Solved

SQL Server 2008R2 Errors creating database on network drive

Posted on 2013-02-05
3
647 Views
Last Modified: 2013-03-18
Hi,

I'm trying to create a new database using a network path but am running into the following error.  Permissions seem to be in place for the account that SQL server service is running under as well as my own.  Sample query is:

CREATE DATABASE [db] ON  PRIMARY
( NAME = N'db', FILENAME = N'\\path\db.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'db_log', FILENAME = N'\\path.db_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

Msg 5123, Level 16, State 1, Line 8
CREATE FILE encountered operating system error 1337(The security ID structure is invalid.) while attempting to open or create the physical file '\\path\db.MDF'.
Msg 1802, Level 16, State 4, Line 8
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Thanks
0
Comment
Question by:tdbj
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
bigbigpig earned 500 total points
ID: 38856938
I believe the account running the SQL service has to have full permissions to the UNC share.  Not read/write/modify, but full.  Check both the share permissions and the NTFS permissions of the remote directory.
0
 

Author Comment

by:tdbj
ID: 38857027
Thanks.  This is in place.

I'm logged into the server using a different set of creds though.  Could that be the source of the issue when the SQL service tries to use the account it's assigned?
0
 

Author Comment

by:tdbj
ID: 38877605
Looking further into this, error 1337 seems to be ERROR_INVALID_SID.

http://www.mssqlforum.com/threads/a-list-of-operating-system-errors.26/

I've checked that the account running the SQL service has full permissions on the share.  I'm connecting to the server under my own account when attempting to create the database.  I also have full permissions on the share.

Any insight would be appreciated.

Thanks in advance
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

778 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