SQL Server 2005 Read-only the wrong solution when attaching a database _mssql

SQL Server 2005 has a read-only error attaching the database file, when attached, the system prompts the MDF file as read-only, but opens the file properties, this property is not read-only. How to solve it? This article we have introduced this solution, next let us come to understand together.

The two solutions are as follows:

1, re-open the database software, in the Login authentication box where choose: Windows authentication to log in. Then attach the database, then there is no read-only attached.

2, in the *.mdf file properties, find the "security" page, and then all of the "group or user name" all the rights of all tick, press OK, just fine.

Then execute: sp_dboption ' database name ', ' Read Only ', ' FALSE ', refresh to see the database name no longer with the read-only, or delete the previously attached database, again in SQL Server appended to the database can also 。 Note: There is no "security" option page in the Friends Properties dialog box, you can open "My Computer"-"Tools"-"Folder Options"-"view", remove the "Use of simple File sharing (recommended)", on it.

About the SQL Server 2005 database read-only The wrong solution is introduced here, I hope this introduction can be harvested for you!