Sqlserver2000 attaching Database Error Solution

This article introduces how to solve the problem of attaching a database to sqlserver2000. If you encounter the same problem, refer to it.

This article introduces how to solve the problem of attaching a database to sqlserver2000. If you encounter the same problem, refer to it.

Title: Microsoft SQL Server Management Studio ------------------------------ unable to retrieve data for this request.
(Microsoft. SqlServer. Management. Sdk. Sfc) help information,

Click: http://go.microsoft.com/fwlink? ProdName = Microsoft + SQL + Server & LinkId = 20476 ------------------------------ Other information: an exception occurred when executing a Transact-SQL statement or batch processing.

(Microsoft. SqlServer. ConnectionInfo) ---------------------------- CREATE or open a physical file d: dbOA. mdf, create file encounters an operating system error 5 (Access denied .). (Microsoft SQL Server, error: 5123) help information,

Click: http://go.microsoft.com/fwlink? ProdName = Microsoft + SQL + Server & ProdVer = 10.00.1600 & EvtSrc = MSSQLServer & EvtID = 5123 & LinkId = 20476

After the SQL statement is reinstalled, you want to append the previous one, but it cannot be attached. The error message is displayed. Solution:

In all programs-SQL Server 2008-Configuration tool-"SQL Server Configuration Manager", click "SQL Server Service" and double-click "SQL Server (MSSQLSERVER) service, select the logon tab, select "Local System" for the built-in account, and click restart.