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
tdbjAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.