Readonly Database - SQL Management Studio Express

punjwani
punjwani used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Did you happen to attach from a CD?
Make sure the mdf file is not read-only

Author

Commented:
I checked both files mdf and ldf attributes are not Read-only.
Commented:
Do the service accounts  have full permissions on the folder?


Have you tried:
sp_dboption 'table name', 'Read Only', 'False'

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial