Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Install Sample Database


We will use the AdventureWorksLT sample database as the data source for the reports we build in this tutorial.  The AdventureWorksLT database was chosen because it is small and the current SQL Server 2008 sample database requires that Full-Text Search be installed, the SQL Full-Text Filter Daemon launcher service is running, and FILESTREAM is enabled.  These requirements just add extra work to get us going so we're going to use the slightly older sample database.

The AdventureWorksLT database is available for download from the following link on the Code Plex site: Microsoft SQL Server Product Samples: Database - Release:SQL Server 2005 SP2a.  Click on the appropriate AdventureWorksLT link to download the installer program for your SQL Server environment: AdventureWorksLT.msi, AdventureWorksLT_x64.msi, or AdventureWorksLT_IA64.msi. 

After downloading the appropriate version of the installer program, run it by double-clicking the .msi file.  You will be prompted for the folder location to put the database and log files.  For a default installation of SQL Server 2008 the folder to choose is:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

Adjust the folder as necessary if you did not accept the default location during installation of SQL Server 2008.

When the installer program completes, you have to attach the database to your SQL Server database engine.  Open SQL Server Management Studio, navigate to the Object Explorer, right click on Databases then select Attach from the menu as shown below:

The Attach Databases dialog will be displayed.  Click the Add button, navigate to the AdventureWorksLT_Data.mdf file in the location you specified when you ran the installer program as shown below:

Click the OK button to attach the database.

Last Update: 1/5/2010

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools