Monday, March 26, 2012

How to connect to AdventureWorks database

I'm trying to connect to the AdventureWorks sample database, after just installing it from the SQL 2005 setup. I was expecting it to automatically appear in SQL Server Management Studio, but it's not there.

How do I get it to show up there?

-Alex

You will have to attach the databases first. they are just deplyoed to the file location specified in the instalaltion path.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

You may not have installed them. If you go through SQL Server 2005's setup, you need to select the sample databases option.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

refer this KB http://msdn2.microsoft.com/en-us/library/aa992075(VS.80).aspx

Madhu

|||While installing the SQL 2005 setup, by default the sample databases option will be disabled. You have to explicitly enable this option to install the sample databases.

No comments:

Post a Comment