SQL server attached database denied access resolution Rollup

@ This article from BaiduMethod One: Modify Permission method

1. 1

   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:

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

   Click the Security tab as shown in:

4. 4

   Click the Edit button as shown in:

5. 5

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

6. 6

   Under "Authenticated Users ' permissions", tick "Full Control", "Full Control" is checked, the following permissions will be automatically checked, as shown in:

7. 7

   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.

   END

Method Two: Switch the authentication Mode method

1. 1

   Sometimes the database cannot be attached successfully and can be resolved by switching the authentication method. The precondition for using this workaround is that the authentication method you used to connect to the database was SQL Server authentication, as shown in. If you were previously connected to Windows Authentication database, can not attach the database, then this method is not suitable for you, please refer directly to the following method three, if you forget the way you are verified, you can first try this method, if not solve the problem, then refer to the following method three.

2. 2

   Click the "Disconnect" button to disconnect the current connection as shown:

3. 3

   Click the "Connect" button to connect to the database server as shown in:

4. 4

   Authentication select Windows Authentication as shown in:

5. 5

   Once you have connected to the database, you can attach the database you want to attach. If the attachment still does not succeed, refer to method three below.

   END

Method Three: Modify the service method

1. Open the SQL Server Configuration Manager program as shown in:

2. On the left, click SQL Server Services, as shown in:

3. Right-click on the right side of SQL Server (MSLHK), select Properties, note that "MSLHK" here is my DB instance name, and on your computer, the database instance name location shows your DB instance name. The operation is as follows:

4. In the pop-up Properties dialog box, under the Login tab, select "Built-in account" as shown in:

5. Change the "built-in account" to "Local System" as shown in:

6. Click "OK" button, will prompt whether to restart the service, click "Yes".

7. After the restart service is complete, check that the "login as" display is not "LocalSystem", and if so, the change takes effect as shown in:

SQL server attached database denied access resolution Rollup