locked
Unable to open the physical file RRS feed

  • Question

  • Hi Experts,

    when i wanted  to move the the ssisdb mdf and ndf files from existing hard disks to another hard disks,i could complete the files movement task.before begin this task i have put the database is in offline mode and after movement has completed ,when i want to take it as online,i am getting the following message.

    Msg 5120, Level 16, State 101, Line 1Unable to open the physical file "D:\SQLDataFiles\SSISDB.mdf". Operating system error 5: "5(Access is denied.)".

    Can i Know the reason and hotfix for this?

    Friday, March 24, 2017 12:04 PM

All replies

  • Unable to open the physical file "D:\SQLDataFiles\SSISDB.mdf". Operating system error 5: "5(Access is denied.)".


    Is that the old or new location? If it's the new location, then you have to grant read/write access for the SQL Server service account; currently the access is denied, as the error message clearly says.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by philfactor Friday, March 24, 2017 1:52 PM
    Friday, March 24, 2017 12:50 PM
  • Hi Olaf Helper,

    Thanq for your reply.

    It is for new location.how can i fix this issue?

    Friday, March 24, 2017 1:26 PM
  • how can i fix this issue?


    As I already wrote, you have to grant permissions: Configure File System Permissions for Database Engine Access

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Monday, March 27, 2017 8:42 AM
    Friday, March 24, 2017 2:00 PM