AdventureWorks 2008 Sample Databases Installer Help

Introduction

Yes, we hear that there are some issues with the current installer. Below is some advice to work around the problems until we can post a new installer which will hopefully correct the issues currently being experienced. Thank you very much for your patience.

Advice

If you are having trouble installing AdventureWorks 2008 SR3 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 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 "AdventureWorks2008" 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.
  • Be sure you have Analysis Services installed. This installer installs all sample databases including the AS sample database.
  • 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. The installation approach using the Zip file (described below) is recommended for SQL Express.
  • SQL Server 2008 is the only release supported for this installer. Installing on SQL Server 2008R2 is not supported. We're working on separate installers for SQL Server 2008R2 which we also hope will clean up these issues. You can try installing on SQL Server 2008R2 using zip files described below, but you'll need to modify the scripts to do so.

If none of the above advice helps, then try installing using the zip file as described below.

Installing using the zip file

  1. Follow all the advice presented in the above section. Almost all of it applies to this technique as well, except for requiring Analysis Services to be installed (unless you want to install the AS database!).
  2. Download SQL2008.AdventureWorks_AllDatabases.zip from http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx, using the open option.
  3. Extract all files to (typically) C:\Program Files\Microsoft SQL Server\100\. The exact destination will depend on how SQL Server was installed.

You can then 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 SqlSamplesDatabase path (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. You'll have to modify this if you intend to install to SQL Server 2008R2. The path looks something like C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ (note the _50 after MSSQL10). SqlSamplesSourceDataPath should be the directory where you unzipped the files (C:\Program Files\Microsoft SQL Server\100\Tools\Samples\) with tools\samples\ added on to the end.
  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.

Installing 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.microsoft.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 Oct 16, 2009 at 12:51 AM by bonniefe, version 8

Comments

jackwchen Nov 30, 2010 at 7: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.