Installing AdventureWorks Analysis Services Database

In this article we will be seeing how to install AdventureWorks Analysis Services Database in SQL Server 2008. Download the database from here.

Here we will be seeing how to do the following

  • Install AdventureWorks Analysis Services Database
  • Deploy AdventureWorks Analysis Services Database

Install AdventureWorks Analysis Services Database:

  1. Download the database.
  2. Run the AdventureWorks2008R2_SR1.exe file.

    AdventureWorks1.gif
     
  3. In the "SQL Server 2008R2 SR1 Database Installer", accept the license terms and click on Next.

    AdventureWorks2.gif
     
  4. In the "Database Selection" wizard, select the script install directory.

    AdventureWorks3.gif
     
  5. "Installation Execution" wizard will pop up which will copy scripts and data files to the specified directory.

    AdventureWorks4.gif
     
  6. Once the installation is completed, click on "Finish".

    AdventureWorks5.gif

Deploy AdventureWorks Analysis Services Database:

  1. Go to Start => All Programs => Microsoft SQL Server 2008 => SQL Server Business Intelligence Development Studio.

    AdventureWorks6.gif
     
  2. Go to File => Open => Project/Solution.

    AdventureWorks7.gif
     
  3. Go to the database installation location and select the solution

    a. For SQL Server 2008:

    i. C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\standard\Adventure Works.sln will contain the solution for SQL Server Standard.
    ii. C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\enterprise\Adventure Works.sln will contain the solution for SQL Server Enterprise and SQL Server Developer.

    b. For SQL Server 2008R2:

    i. C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Analysis Services Project\standard\Adventure Works.sln will contain the solution for SQL Server Standard.
    ii. C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Analysis Services Project\enterprise\Adventure Works.sln will contain the solution for SQL Server Enterprise and SQL Server Developer.
     
  4. Solution Explorer looks like the following.

    AdventureWorks8.gif
     
  5. In the solution explorer, go to Data Sources and double click on "Adventure Works.ds".

    AdventureWorks9.gif
     
  6. In the "Data Source Designer" wizard, click on Edit.

    AdventureWorks10.gif
     
  7. Enter the server name and select the database in the "Connection Manager" wizard, Click on "Test Connection".

    AdventureWorks11.gif
     
  8. Right click on the solution explorer, choose properties. You will get the following dialogue box, change the target server property to your server name.

    AdventureWorks12.gif
     
  9. Right click on the solution explorer, click on Deploy.

    AdventureWorks13.gif
     
  10. Now the database is deployed successfully.
  11. Go to Start =>All Programs => Microsoft SQL Server 2008 => SQL Server Management Studio.
  12. Select the server type as "Analysis Services" and enter the server name.

    AdventureWorks14.gif
     
  13. Click on Connect and you could be able to see the Adventure Works database.

    AdventureWorks15.gif