SQL Server attached database denied access

2. Open the folder that contains the database file that you want to attach, which is the same folder as the file that has the. mdf extension, as shown in:

3. Right-click the MDF file and select Properties, as shown in:

4. Click the Security tab as shown in:

5. Click the Edit button as shown in:

6. In the popup dialog box, select "Authenticated Users" in "group or user name" as shown in:

7. Under Authenticated Users ' permissions, tick "Full Control", "Full Control" is checked (remember that the . log file is also fully controlled ), and the following permissions will be automatically checked as shown:

8. Finally click "OK" to do it. Once you have modified the permissions, you will be able to attach the database successfully. This is the most common method, the success rate is relatively high, occasionally unsuccessful cases, please refer to the following two methods.

SQL Server attached database denied access