To install the sample databases and companion samples during setup, use the following instructions.

1. On the Components to Install page, select Workstation components, Books Online and development tools.
   
2. Click Advanced and then expand Documentation, Samples, and Sample Databases.
   
3. Select Sample Code and Applications.
   
4. Expand Sample Databases and then select the sample databases to install.
   

   Note:
   The OLAP database (Adventure Works DW) cannot be installed unless the data warehouse (AdventureWorksDW) database is selected for installation. The analysis services project, Adventure Works DW must be deployed before the Adventure Works DW analysis services database can be accessed.

5. To complete the installation of the samples, after setup, perform one of the following steps:
   
   1. From the Start menu, click All Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials, click Samples, and then click Microsoft SQL Server 2005 Samples.
      
   2. Alternatively, using Windows Explorer, navigate to <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\ and double-click SqlServerSamples.msi to launch the installer.
      

   Important:
   The samples are installed to <drive>:\Program Files\Microsoft SQL Server\90\Samples. Be sure to read and follow the installation instructions in the Readme files that accompany the samples you want to use. For a list of samples, see Samples.

If you did not install the sample databases or samples during the initial setup of SQL Server 2005, you can install them later.

Important:
You cannot use the following procedure to re-create a sample database that has been deleted. To re-create a deleted sample database, reinstall the database from the installation script. For more information, see Reinstalling Sample Databases from Script.

1. From Add or Remove Programs, select Microsoft SQL Server 2005 and click Change. Follow the steps in the Microsoft SQL Server 2005 Maintenance wizard.
   
2. From Component Selection, select Workstation Components and then click Next.
   
3. From Welcome to the SQL Server Installation Wizard, click Next.
   
4. From System Configuration Check, click Next.
   
5. From Change or Remove Instance, click Change Installed Components.
   
6. From Feature Selection, expand the Documentation, Samples, and Sample Databases node.
   
7. Select Sample Code and Applications.
   
8. Expand Sample Databases and then select the sample databases to be installed. Click Next.
   
9. To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
   The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use.
   
10. To install the sample database files without attaching, from Sample Databases Setup, select Install sample databases without attaching, and then click Next.
    The AdventureWorks database files are created in the folder <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP. AdventureWorksDW files are created in the <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Data Warehouse folder. You must attach the database before you can use it. For more information, see Detaching and Attaching Databases.
    
11. Select the instance of SQL Server on which to install the sample databases and samples.
    
12. Complete the steps in the wizard.
    
13. To complete the installation of the samples, after setup, perform one of the following steps:
    
    1. From the Start menu, click All Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials, click Samples, and then click Microsoft SQL Server 2005 Samples.
       
    2. Alternatively, using Windows Explorer, navigate to <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\ and double-click SqlServerSamples.msi to launch the installer.
       

    Important:
    The samples are installed to <drive>:\Program Files\Microsoft SQL Server\90\Samples. Be sure to read and follow the installation instructions in the Readme files that accompany the samples you want to use. For a list of samples, see Samples.

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.
   
2. Make sure Analysis Services has been installed.
   
3. From the SQL Server Business Intelligence Development Studio toolbar, click File, point to Open, and then click Project/Solution.
   
4. Browse to <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project, select the file Adventure Works.sln, and then click Open.
   
5. From Solution Explorer, right-click Adventure Works DW and select Deploy or Process.
   

Tasks

Concepts

Other Resources

Help and Information