AdventureWorks 2008 Sample Databases Installer Help

Introduction

In response to your feedback we've posted an updated installer which we hope will address your concerns.

Advice

If you are having trouble installing AdventureWorks 2008 SR4 sample databases here is some advice which you may find helpful:
  • Be logged in as an administrator, or have an administrator grant access to the directories you will be modifying (see below). Be in the sysadmin role on the installation instance.
  • Remove all previous releases of SQL Server 2005 and 2008 AdventureWorks sample databases if present. Actually inspect the DATA directory of the installation instance (the exact path depends on the instance, but a typical path is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA) and make sure any files or directories which begin with "AdventureWorks" or "Documents" are removed. If you can't delete files in this directory, try stopping your SQL Server instance first.
  • Be sure all prerequisites are installed and configured properly. See Database Prerequisites for details.
  • If you are running on Windows XP or Windows Server 2003, you may be hitting a windows bug which prevents installation. The current work around is to run SQL Server under an account other than NT Authority\Network Server. Local System works just fine. Use SQL Server Configuration Manager to change the Log On As account of the installation instance. We are working with the Windows team to get a QFE out ASAP that fixes this issue.
  • If you are trying to install onto SQL Express, be sure to use SQL Server Express with Advanced Services.
  • This installer is for SQL Server 2005 and SQL Server 2008 sample databases. If you need SQL Server 2008R2 sample databases, the installer is located here.

Manually creating databases

  1. Follow all the advice presented in the above section. All of it applies to this technique as well,
  2. Use the SQL Server Management Studio (SSMS) GUI or the SQLCMD console application to install the databases.

SQL Server Management Studio (SSMS) approach

  1. Start SSMS
  2. Click File / Open / File...
  3. Navigate to C:\Program Files\Microsoft SQL Server\100\Tools\Samples\
  4. Navigate to AdventureWorks 2008 OLTP, AdventureWorks 2008 Data Warehouse, or AdventureWorks 2008 LT, depending on which database you wish to install.
  5. Select the database installation script (instawdb.sql for OLTP, instawdwdb.sql for the Data Warehouse, or instawltdb.sql for LT). Click Open.
  6. Connect to the instance where you want to install the database using the Connect To Database dialog which pops up.
  7. Enable SQLCMD mode (click Query / SQLCMD)
  8. Locate the part of the script which contains two lines that begin with --:setvar
  9. Uncomment them (remove the -- part).
  10. Look at the paths and make sure they are accurate for your instance. For SqlSamplesDatabasePath (the first one) if you are not sure, run the following query in the installation instance: select physical_name from master.sys.database_files where name = 'master'. The directory part of the result should match, and there should be a trailing backslash (\) after the last part of the directory path. Typically the path in the script is accurate for the default instance.
  11. Click ! Execute

The database should be installed. Repeat for the other databases you wish to install.

SQLCMD approach

This approach is especially useful for SQL Express customers who may not have SSMS installed.
  1. Start a Command Prompt, running as administrator.
  2. Type set SqlSamplesDatabasePath=C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\, updating the path depending on installation instance (see the path discussion in the SSMS section).
  3. Type set SqlSamplesSourceDataPath=C:\Program Files\Microsoft SQL Server\100\Tools\Samples\, again updating the path as discussed in the SSMS section.
  4. CD to C:\Program Files\Microsoft SQL Server\100\Tools\Samples\
  5. CD to AdventureWorks 2008 OLTP, AdventureWorks 2008 Data Warehouse, or AdventureWorks 2008 LT, depending on which database you wish to install.
  6. type SQLCMD -S ServerName -E -i ScriptFileName where ServerName is the name of your server for the default instance, and the name of your server plus a backslash and the name of your instance for an instance other than the default one. ScriptFileName should be instawdb.sql for OLTP, instawdwdb.sql for the Data Warehouse, or instawltdb.sql for LT.

The database should be installed.

Deploy the AS Database

  1. Open the appropriate AS database solution for your edition of SQL Server (typically C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\enterprise\Adventure Works.sln for enterprise and developer editions, and C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\standard\Adventure Works.sln for standard edition in BI Development Studio. If you don't have BI Development Studio then your edition of SQL Server may not support this database.
  2. Click right on Adventure Works DW 2008 in the solution explorer then click Deploy.

Conclusion

If for some reason all of this fails, and you've followed all the advice in this document, then please file a work item on http://msftdbprodsamples.codeplex.com under the Item Tracker tab. Please include operating system, version of SQL Server, any error messages including screen captures or text captured from the command prompt window. Thanks very much!

Last edited Dec 10, 2009 at 9:52 PM by bonniefe, version 15

Comments

jackwchen Nov 30, 2010 at 8:40 PM 
I installed AdventureWorks 2008R2 SR1 by following the "SSMS approach" and "Deploy the AS Database". I have a name instance of SQL Server 2008 R2 Developer in a Windows 7 Professional 64-bit running in HP ProBook 6550b with Intel Core i5.