SQL Server import MDF and LDF files appear: unable to open physical file “D:\ XX.mdf “。 Operating system error 5: “5 (access denied. )”Solutions

Right click on one of the databases in SQL Server Management Studio, select “New Query”, and run:

EXEC  sp_attach_db  @dbname  =  'store',     
@filename1  =  'D:\XX.mdf',     
@filename2  =  'D:\XX_log.ldf'

Press F5 or run button to execute.
Console output: appears
Unable to open physical file “D:\XX. MDF “. Operating system error 5:”5(access denied). ”

error log information:
Setting database option MULTI_USER to ON for database store.
Starting up database ‘store’.
error: 17204, severity: 16, status: 1.
FCB::Open failed: Could not Open file D:\store\store. MDF for file number 1. OS error: 5(denied access)
error: 17204, severity: 16, status: 1.
FCB::Open failed: Could not Open file D:\store\store_log.ldf for file number 2. OS error: 5(denied access)
error: 5105, severity: 16, status: 1.
A file activation error occurred. The physical file name’d :\store _store_log.ldf may be pen. account and correct additional errors, and retry The operation.
error: 928, severity: 20, status: 1
During upgrade, database raised exception 945, database raised exception 14, state 2, address 00000000009F3BD7. Use the exception number to determine the cause.

Solutions:
In the directory where the database resides, the folder where the MDF and LDF files are stored, right-click the folder — properties — security — Add the SqlServer service startup account or Everyone — check the box “Complete Control” — to exit.

Finally, rerun the above code.


Read More: