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

SQL Server 2008 Forums

Transact-SQL (2008)

install sample Database in SQL 2008

Author

Topic

liveinla
Starting Member

5 Posts

Posted - 2011-03-28 : 13:44:34

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 copies the Northwind.mdf to ..MSSQL/DATA folder and selects Attach in the Database node to add the new database. 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.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-03-28 : 14:45:19

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=158741

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources