Share via

Walkthrough: Installing the AdventureWorks OLTP and LT sample databases

  • Article

[WCF RIA Services Version 1 Service Pack 2 is compatible with either .NET framework 4 or .NET Framework 4.5, and with either Silverlight 4 or Silverlight 5.]

The WCF 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 2010, the Silverlight 4 Developer Runtime and SDK, and WCF RIA Services and its Toolkit must also be installed to use the RIA Services walkthroughs. The installation points for these programs are provided in the Prerequisites for WCF RIA Services topic.

Installing the Adventure Works OLTP and LT Databases

To install the Adventure Works sample databases

  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.

  2. Run AdventureWorks2008R2_SR1.exe

  3. Click the I agree the license terms check box, then click the Next button.

  4. Select Run in the File Download window and then Yes in the User Account Control window when it appears.

  5. 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.

  6. 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.

  7. 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.

  8. When the installation completes click the Finish button.