Haha: sqlserver2008 The workaround for operating system error 5 (Access denied) error 5012 when attaching a database

The teacher said: No matter what, wrong, first laugh three. If more people, in the heart also want to laugh three. HA haha!!!

After the system has just been re-installed, and then want to learn. Install the sqlserver2008 database yourself, and then you want to attach the previous database. But when I had a little certainty about the button, there was this error.

I looked at this picture and I wondered about the big day. How to solve all can not solve.

I thought it was the reason for the logon method, and then switched the login mode: Hybrid authentication method (SQL server Authentication, logon mode changed to "Windows Authentication mode.") But it's not going to work out.

I looked up the information on the Internet. Finally solved.

In order to be someone who may have encountered such a thing.

I have to share my story with you. Hope to help everyone, at the same time, if there are good views we have a lot of exchanges Ah!

Solution:

Select All Programs -sql Server 2008-Configuration Tools -Select SQL Server Configuration Manager orSQL Server Config manager,

Open theSQL Server Configuration Manager config interface, select SQL Server 20058 services on the left , and right-click on the right sideof the SQL Server attribute, change the network service to the Local system in the built -in account,

Click "Restart" and then attach the database is OK.

The main configuration process is as follows:

1. Open the "SQL Server configuration Manager" Config interface:

2. Select the SQL Server (SQL Server) option, and right-click:

3. Select "Local System":

4. Select "Restart":

5. Configuration success:

Haha: sqlserver2008 The workaround for operating system error 5 (Access denied) error 5012 when attaching a database