Post reply

Create a data base on specific data file or log file

  • July 7, 2013 at 2:07 pm

    #277093

    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

    #1630273

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply