After attaching, the database property is invented as a read-only solution

1. Open sqlserver Configuration Manager and enable the properties of SQLServer2005 service-SQL Server (SQLEXPRESS. in the built-in account, change the network service to a local system. After starting SQLServer2005Express from the beginning, attach the database. 2. Open SqlServer2005, right-click on the read-only database, and select

1. Open the SQL server Configuration Manager and enable the SQL Server service-SQL server (SQLEXPRESS) attributes. in the built-in account, change the network service to a local system. After starting SQL Server 2005 Express from the beginning, attach the database. 2. Open SqlServer 2005, right-click on the read-only database, and select

1. Open the SQL server Configuration Manager and enable the SQL Server service-SQL server (SQLEXPRESS) attributes. in the built-in account, change "Network Service" to "Local System", start SQL Server 2005 Express from scratch, and then attach the database.

2. Open SqlServer 2005, right-click on the read-only database and select Properties. On the left side of the Properties window, select "options" under "Select page ", on the right side of the window, change "database as read-only" to "false". Click "OK.

Summary: The reason why the attached database is "read-only" is that the default "Network Service" account for starting SQL Server is attached (Attach) the Database File Permission does not match.

In addition

"The physical file cannot be opened" E: \ works \ database \ northwnd. mdf ". Incorrect operating system 5: "5 (rejected .) ". (Microsoft SQL Server, error: 5120) "The solution to this problem is similar. You only need to select" Local System "for the built-in account and click" start from scratch ".