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 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.