SQL Server 2008R2 Errors creating database on network drive
Posted on 2013-02-05
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 )
( NAME = N'db_log', FILENAME = N'\\path.db_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
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.