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-clickDatabase Engine, point toNew, and then clickServer Registration. TheNew Server Registration dialog box opens. In theServer name text box, type the name of your SQL Server instance. In theRegistered server name box, typeAdventureWorks.On theConnection Properties tab, in theConnect to database list, selectAdventureWorks, and then clickSave.
[791 byte] By [
mlopez] at [2008-2-8]
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
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.
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.