SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2008

Note: Download SQL Server 2008 AdventureWorks database by Microsoft

The following sample databases are currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:

  • The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
  • The Adventure Works DW database demonstrates how to build a data warehouse.
  • The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
  • The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.

Download SQL Server 2008 AdventureWorks database

For installation instructions please refer my previous article here.

Abstract courtesy : Microsoft

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

24 thoughts on “SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2008

  1. Hi Pinalkumar,

    I am encountering the following errors when I tried to install AdventureWorks Sample (SQL Server 2008 SR4) on SQL Server 2008 Express. The errors shown at page 2 of install wizard after accepting the license.

    Failed object initialization (ISupportInitialize.EndInit). An exception occurred while executing a Transact-SQL statement or batch. Error at object ‘DatabaseSelection’ in markup file ‘DatabaseInstaller;component/databaseselection.xaml’ Line 78 Position 3.

    Any advises on what could be the cause?

    Thanks!

    • Hallo Eunice

      I don’t know if you have already the solution but I had the same problem.
      The mistake I made was that I installed the examples with an other user then the user I used during the installation of Server 2008.
      So try to install the examples with the same user you used during installation of server 2008.

      I hope that it solves your problem.

      Greetings Gerald – The Netherland

  2. I am looking for help please

    I am setting up a laptop for testing SQL 2008 reporting services and have installed Vista business then a full install of SQL2008. (from Microsoft action pack)

    I have downloaded adventureworks but when I try to install Adventureworks2008_SR4 I receive the following error

    Failed object initialization (ISupportInitialize.Endit).Method not found: ‘system.string
    Microsoft.SqlServer.Management.Smo.Server.get_InstallDataDirectory()’
    Error at object ‘Database selection’ in mark up file ‘DatabaseInstaller;Component/databaseselection.xaml’ line 78 position 3

    I note the solution above, however I only have one admin user set up on the laptop

  3. hello Mr. Pinal Dave,
    I am a regular to your website…i just admire you like sachin tendulkar,.,,

    Ok,,,I am having this huge problem of installing AdventureWorks2008 database into my sql server 2008 enterprise edition …i have bought some books for studying sql server reporting and integration services, and each of these books are using the Adventureworks2008 database,,and the links that you have provided are not working ,,, and also i have downloaded and installed the AdventureWorks2008_SR4.exe found at http://msftdbprodsamples.codeplex.com/releases/view/37109 but of no help,,,I have run the exe file that i downloaded but the database does not show up in SSMS or in any other Data source wizards…can you please help me ??? thank you sir…

  4. Hi all, i had the same problem as Eunice and the reason for my problem was because i had 2 instances of SQL Server installed i.e. the Default instance and an SQL Express instance. To solve this problem i simple stopped teh SQL Express instance service (since i wasn’t using it) and it installed successfully.

  5. Hi,

    Im turning grey.

    Well not literally, but I have tried so many things to try to install AdventureWorks 2008(both 2008_SR4 and 2008R2_RTM). Every time the exact same result; a sudden shutdown of the pc. NO IDEA why…

    I run Win7, have 2 GB RAM (67% free), have SQL Server 2008R2 installed, but ADventureWorks does not want to oblige.

    Anyone any idea?

  6. Hi, Me too was getting following error.
    -*—————————————–
    Failed object initialization (ISupportInitialize.Endit).Method not found: ‘system.string
    Microsoft.SqlServer.Management.Smo.Server.get_InstallDataDirectory()’
    Error at object ‘Database selection’ in mark up file ‘DatabaseInstaller;Component/databaseselection.xaml’ line 78 position 3
    -*—————————————–

    As somebody already mentioned I changed logged in user on SQL Server and SQL Server Agent and did the installation with the same. It worked.

    My OS is Windows XP SP3.
    – Rahul

  7. Got the same error:
    Failed object initialization (ISupportInitialize.Endit).Method not found: ‘system.string
    Microsoft.SqlServer.Management.Smo.Server.get_InstallDataDirectory()’
    Error at object ‘Database selection’ in mark up file ‘DatabaseInstaller;Component/databaseselection.xaml’ line 78 position 3

    Turned out I got it because I didn’t have the downloaded file in the right folder. It needs to be in C:\Program Files\Microsoft SQL Server\MSSQL10_50.”named instance(i.e. SQLEXPRESS)” folder before you try to extract it.

  8. Pinal,

    I’m getting errors for a book sample query (SSRS) vs. the AdventureWorks2008DW database.

    It turns out I’m missing table DimDate which, supposedly, is in AdventureWorks20008DW (Rel 1) version of the database, not the R2 version I downloaded. I cannot track down the R1 version.

    Is there a way I can make R2 database compatible with earlier version, or where can I find original AdventureWorks2008DW database?

    Thanks,

    Zee

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s