Solved

SQL Server 2008R2 Errors creating database on network drive

Posted on 2013-02-05
3
657 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 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

690 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