Walkthrough: Installing the AdventureWorks OLTP and LT sample databases

[ This document was written for WCF Services Version 1 Service Pack 2 and might not be up to date Please see Release Notes or Changelog for a list of changes since WCF RIA Services ]
The Open Ria Services walkthroughs assume that you have the AdventureWorks OLTP and LT databases installed. This walkthrough outlines the steps needed to create an instance of AdventureWorks OLTP and LT databases.
Important: Make sure you have a compatible installation of SQL Server 2008 R2 Express with Advanced Services or any retail version. The procedure for installing SQL Server 2008 R2 Express with Advanced Services is outlined in the Walkthrough: Installing and Configuring SQL Server 2008 R2 Express with Advanced Services topic.
Warning: Visual Studio, the Silverlight 4 Developer Runtime and SDK, and Open Ria Services and its Toolkit must also be installed to use the Open Ria Services walkthroughs. The installation points for these programs are provided in the Prerequisites for Open Ria Services topic.

Installing the Adventure Works OLTP and LT Databases

To install the Adventure Works sample databases

  1. 1.
    Download the installer for AdventureWorks Sample Databases​
[!IMPORTANT] By default Windows Server 2008 security is configured to prevent the download of these installers. Changing the security configuration is not recommended on production servers. Please see the Windows Server documentation for information on how to change these settings.
  1. 1.
    Run AdventureWorks2008R2_SR1.exe
  2. 2.
    Click the I agree the license terms check box, then click the Next button.
  3. 3.
    Select Run in the File Download window and then Yes in the User Account Control window when it appears.
  4. 4.
    Use the pull down selector Installation Instance to choose the instance in which to install the databases from the Database Selection windows when it appears.
  5. 5.
    While it is possible to change the directory where the scripts and data files will be installed, it is recommended that the default be used.
[!IMPORTANT] If the directory is changed, be sure that the account the SQL Server service runs under has read access to this directory.
  1. 1.
    Ensure that boxes for installing the AdventureWorks OLTP 2008R2, AdventureWorks LT 2008R2, AdventureWorks OLTP, AdventureWorks LT databases are all checked. Leave the default for all other databases. Click the Install button.
  2. 2.
    When the installation completes click the Finish button.