SQL cannot open physical file Xxx.mdf ", operating system error 5:" 5 (Access denied.) )"

When attaching a database with the T-SQL command, the following exception message appears:

Unable to open physical file Xxx.mdf ". Operating system error 5: "5 (Access denied. )"。 (Microsoft SQL Server, error: 5120)

Solution:

Find XXX. MDF and Xxx_log. LDF file, right-properties-security-Add authenticated users-at the group or user name to change the group permissions to full permissions and attach successfully again.

--------------------------------------------------------------------------------------------------------------- ------------

SQL cannot open physical file Xxx.mdf ", operating system error 5:" 5 (Access denied.) )"