install sample Database in SQL 2008

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

install sample Database in SQL 2008

Author

Topic

liveinla
Starting Member

5 Posts

Posted - 2011-03-28 : 14:13:07

Hi,

I have bought the book Microsoft SQL server 2008 database development training kit. I will to follow the instruction to install the 3 samples on the CD to MS Sql 2008 from the SQL management Studio as described on introduction page.(Basicaly it copy the Northwind.mdf to ..MSSQL/DATA folder and select Attach in the Database node. But I got an error saying that

TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'IBM-PC'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=3415&LinkId=20476
------------------------------
BUTTONS:
OK

Hope someone could help, thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources