Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Create a data base on specific data file or log file Expand / Collapse
Posted Sunday, July 7, 2013 2:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 24, 2015 2:56 AM
Points: 42, Visits: 125
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
Post #1470989
Posted Sunday, July 7, 2013 2:13 PM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1470990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse