Error in attaching database to 2005 Express | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in attaching database to 2005 Express

I’m trying to attach a MSDE 2000 database to SQL Server 2005 Express. I simply issue sp_detach_db XXX where XXX is the name of my MSDE database. Then sp_attach_db or create database … with attach and both way gets the following message: Event ID. : 3415 Description: Database ‘XXX’ cannot be upgraded because it is
read-only or has read-only files. Make the database or files writeable, and
rerun recovery. What does it mean? I have solved this issue by changing the service account of SQL Server to LocalSystem. But still want to know the reason. Thanks for any help, Peter
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>