Re: Problem attaching Northwind traders sample database in SQL Server 2005

Hmm. Thanks for sharing this info!

I'm glad your problem has been solved.

--
Ekrem Önsoy



"Paul" <paul_NoSpam@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:C6A7CF62-13E6-4D39-94BC-4FFACC6B20D2@xxxxxxxxxxxxxxxx
thanks for checking. While the files were not flagged as 'Read-only' in the file system, the user account that my instance of SQl Server was using didn't have sufficient rights to the file. Oddly, i didn't have this come up in XP, but it happened in Vista.

Thanks again for the help!

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message news:13C74D2E-93C5-43B9-BF44-B88C2478FEC0@xxxxxxxxxxxxxxxx
I recreated the scenario in my test environment and the problem is database files are read-only.

--
Ekrem Önsoy



"Paul" <paul_NoSpam@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:%237ALlw4$HHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
I'm having some trouoble attaching the Northwind sample to an instance of SQL Server 2005 on Vista. When I attempt to attach the database I receive an error:

Database 'Northwind' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error:3415)

I have been able to attach other samples, such as adventureworks, so I think it is something to do with attaching SQL 2000 developed databases, and my security settings.

Thanks for any advice.



.

Relevant Pages

  • Re: FCB::RemoveAlternateStreams: Operating system error (null)
    ... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
    (microsoft.public.sqlserver.setup)
  • Re: Replication Question
    ... Depending on the size of your db and transaction logs, ... or as Paul has mentioned use Log Shipping. ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: changing db location on sql2000
    ... "Kevin3NF" wrote in message ... "Ekrem Önsoy" wrote in message ... to Server Properties by right clicking on the Instance name and go to "Database Settings" tab in the SQL Server Properties window. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multiple Access vs. SQL
    ... I have to agree with Paul, it depends on your usage patterns. ... I successfully deployed a web-based application which supports thousands of users on Access databases - with no more than a few simultaneous connections per Access database. ... In fact there's a white paper floating around at Microsoft that says that Access performs better than SQL Server with one or two users. ...
    (microsoft.public.sqlserver)
  • Re: changing db location on sql2000
    ... Thanks Ekrem. ... "Database Settings" tab in the SQL Server Properties window. ...
    (microsoft.public.sqlserver.setup)