July 7, 2013 at 2:07 pm
Hello
I'm going to create a data base on data file but i saw this errors ,I know one of them is relatetd to user permission but I don't know how can i change the permission.
Msg 5123, Level 16, State 1, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\Data\testdatafile.mdf'.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
thanks alot
July 7, 2013 at 2:13 pm
The SQL Server service account needs full permission on the folder. Go to the folder, the the security settings and give the account that SQL is running under full permissions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply