Installing Sample Databases
By default Windows Server 2008 security is configured to prevent the download of these installers. Changing this security configuration is
recommended on production servers. Please see Windows Server documentation for information on how to change these settings.
To install one or more the sample databases for SQL Server 2008 perform the following steps:
- Ensure all prerequisites are met. See
Database Prerequisites for detailed prerequisite instructions. Note that some databases will not install unless all prerequisites are met.
- Using the object explorer in SSMS delete any earlier version of the AdventureWorks sample databases you may have installed. Close any open connections when deleting the databases.
- Using the file explorer ensure all .MDF and .LDF files have been deleted from the
data directory for all sample databases in the instance you will be installing the new sample databases. For the default instance, the path to the data directory for OLTP, LT, and DW sample databases is typically
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.
- Navigate to
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx, click on the installer (AdventureWorks2008_SR4.exe) and respond to all the dialogs presented by the installer as detailed below.
Click the Run
button in the File Download - Security Warning dialog
Click the Open
button in the download dialog
Click the Run
button in the Internet Explorer - Security Warning dialog. It may be necessary to allow execution in a UAC dialog.
The script and data files along with the database installer application will download to a temporary directory.
Review the license agreement and click the "I accept the license terms" check box if you agree, then click the
The instances on the local machines are examined. Use the Installation Instance combo box to select which server instance will be used. On the bottom part of the dialog is a list of databases included in the install. All scripts and data files for these databases
will be copied to the directory you specify in the "Script Install Directory" text box. In addition, any checked databases will also be automatically created in the selected instance. If a warning icon is displayed, then that particular database
cannot currently be installed automatically in the selected instance. This might be because one or more prerequisites are not met for the selected instance, or because, for example, the OLAP databases cannot currently be automatically deployed. In the case
of the OLAP databases you can manually deploy the databases once the rest of the installer completes. All eligible databases will be created by default. Uncheck any databases you do not want to automatically create. Click
to begin the copying and database creation actions.
This dialog displays installation progress (both overall and for the particular database being created) and any issues which arise during the database creation process.
Optionally click Show Details
to see a list of detailed actions taken during the database process, or to examine any failures which might occur. It is possible to type Control-A Control-C in the details text box to capture the context of any installation
failure and either paste in email or in a work item for reporting a bug.
When the installation is complete, click the Finish