SQL Server attached database failed to open the physical file, operating system error 5 text solution Tutorial _mssql

Problem Description:

When attaching data, you are prompted not to open the physical file, operating system error 5. The following figure:

Problem reason: May be a problem with file access permissions.

Solution: Locate the MDF and LDF files for the database, and grant permissions . The following figure:

Find MDF and LDF files, this demo takes LDF as an example.

1. Click the file right key property--> Security--> Edit

2. Edit--> Add

3. Add--> Advanced

4. Advanced--> Find--> search results immediately-->everyone--> determine--> determine

5. Determine the permissions of the Everyone user-->everyone selected by default-->--> check "Full Control" will be all of the following are not checked by default check.

--> determine--> determine. That is, everyone's permissions are complete.

The above is a small set to introduce SQL Server additional database error can not open the physical file, operating system errors 5 graphics and text solution tutorial, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!