SQL Server attached database access Denied Error resolution method

Today, when attaching a database in MSSQL, I am prompted for operating system error 5 (Access denied), here I did not give two solutions for everyone to solve the problem.

Scenario One: Switch login mode This occurs because of the "Mixed authentication Mode" (SQL Server Authentication) log on to the database, as long as the login to the "Windows authentication method" Login To resolve the problem, the additional success after the "Mixed authentication Mode "There's no problem with landing.

Scenario Two: Modify the service Select All Programs-sql Server 2005-Configuration Tools-Select SQL Server Configuration Manager or SQL Server Config Manager to open the SQL Server Con figuration Manager "Configuration Interface, select" SQL Server 2005 Services "on the left, and right-click on the right side of the" SQL Server (SQLEXPRESS) "property to open the Network service in the built-in account Change to Local System – "local", click "Restart" and then attach the database is OK

SQL Server attached database access Denied Error resolution method