asked on Readonly Database - SQL Management Studio Express
I have database setup on one server using SQL 2005 now when I try to detach and attached that database on workstation with SQL Server Express 2005, it came up as Readonly message I get this message when try to alter database.
Message is "Failed to Update databse "database name" because the database is read-only. (Microsoft SQL Server, Error: 3906)".
Server: Windows 2003, SQL 2005, Database compatibility level is SQL Server 2000 (80)
Workstation: Windows XP Professional, SQL Express 2005, Compatibility level SQL Server 2005 (90)
Note: I am not able to change the compatibility level on workstation because its readonly.
Thanks
Message is "Failed to Update databse "database name" because the database is read-only. (Microsoft SQL Server, Error: 3906)".
Server: Windows 2003, SQL 2005, Database compatibility level is SQL Server 2000 (80)
Workstation: Windows XP Professional, SQL Express 2005, Compatibility level SQL Server 2005 (90)
Note: I am not able to change the compatibility level on workstation because its readonly.
Thanks
Microsoft SQL Server 2005
Last Comment
punjwani
ASKER
I checked both files mdf and ldf attributes are not Read-only.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I copied database in seprate folder on C drive, now I copied it in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and it worked.
Thanks I think it was permission issues, it resolve by copying it to default folder.
Thanks I think it was permission issues, it resolve by copying it to default folder.
Make sure the mdf file is not read-only