Registering AdventureWorks

The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:\ProgramFiles\Microsoft SQL Server\90\Tools\Samples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection Properties" tab of New Server Registration.

I am familiar with database development as it relates to MS Access but I realize this is a whole new ball of wax. Any advise would be appreciated as it relates to this problem but also any information, i.e., very basic books on learning SQL Server would also be appreciated.

Treasa

The database samples only install as physical files, they are not attached to the SQL Server process. If you want to use them, go in the SSMS and right click on the Database node, choose All Tasks and click Attach database.. Locate the MDF File and the LDF File and click Apply (or OK). SQL Server will attach the databases to the SQL Server process and you can access the data.

HTH, Jens Suessmeyer.

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

Hi,

I advice you to uninstall 2005 and install it again. When you

running the setup push the advanced options and choose the option of books online and samle database also (at the bottom) and make it available at setup. this will help you to save lots of time.

Tomer

|||

another option is when you install the adventureworks install in with attach option - this way it will attach the database dierctly to your sql server. Also try and see if you have under msql folder --> data a file name adventureworks.mdf --> if you have it you need to attach it by right click on the server container and all tasks attach and choose the mdf file.