?
Solved

SQL Server 2008R2 Errors creating database on network drive

Posted on 2013-02-05
3
Medium Priority
?
661 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
[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
3 Comments
 
LVL 10

Accepted Solution

by:
bigbigpig earned 1500 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

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

771 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