How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)
|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.
|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.