Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

SQL Server 2008R2 Errors creating database on network drive

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
tdbj
Asked:
tdbj
  • 2
1 Solution
 
bigbigpigCommented:
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
 
tdbjAuthor Commented:
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
 
tdbjAuthor Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now