Home > SSAS > SSAS – Install Analysis Services and Adventure Works on Vista

SSAS – Install Analysis Services and Adventure Works on Vista

SQL Server 2005 Developer Edition – Installation Procedure

  • Install Disc 1: install default instance
    • Database Services: SHERRY-PC
    • Analysis Services: SHERRY-PC
    • Reporting Services: SHERRY-PC\ReportServer
    • Notification Services
    • Integration Services: SHERRY-PC
    • SQLXML4
  • Remove Workstation Component before install Disc 2
    • Go to Control Panel
    • Go to Program Features
    • Select SQL Server 2005
    • Click Uninstall
    • Select Workstation Component
  • Install Disc 2: Tools. Install locally
    • Install Business Intelligence Development Studio (BIDS)
    • Install Management Studio
    • Install SQL XML4
    • Install Sample database
  • Install SQL Server 2005 SP 2
    • Download from internet
    • Accept all defaults
  • Install the AdventureWorks sample databases
    • AdventureWorks: OLTP
    • AdventureWorksDW: OLAP
    • Adventure Works DW: SSAS
    • Install after the Setup
    • From Add or Remove Programs, select Microsoft SQL Server 2005 and click Change. Follow the steps in the Microsoft SQL Server 2005 Maintenance wizard.
    • From Component Selection, select Workstation Components and then click Next.
    • From Welcome to the SQL Server Installation Wizard, click Next.
    • From System Configuration Check, click Next.
    • From Change or Remove Instance, click Change Installed Components.
    • From Feature Selection, expand the Documentation, Samples, and Sample Databases node.
    • Select Sample Code and Applications.
    • Expand Sample Databases and then select the sample databases to be installed. Click Next.
    • To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
    • The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use.
    • Select the instance of SQL Server on which to install the sample databases and samples.
    • Complete the steps in the wizard.
    • To complete the installation of the samples, after setup, perform one of the following steps:
    • From the Start menu, click All Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials, click Samples, and then click Microsoft SQL Server 2005 Samples.
  • Now the above has installed Adventure Works Analysis Services Project in the folder "C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project". There you will find 2 sub-folders: "Enterprise" and "Standard". If you have SQL Server Enterprise or Developer edition, then use project from Enterprise sub-folder as it has features available just in SQL Server Enterprise Edition.
  • Tip for Windows Vista users: if you are doing installation from/on Windows Vista OS, copy sample project out of "c:\Program Files" folder to folder C:\Download\SQL SSAS Project\Enterprise. In Windows Vista this folder has extra security and you might not be able to save changes in project files as files will be read-only.
  • In BIDS, open the above project, and examine the design, cubes, dimensions, etc. Then Build the application. This will create the Adventure Works DW.asdatabase file in folder C:\Download\SQL SSAS Project\Enterprise\bin
  • Start à All Programs à SQL Server 2005 à Analysis Services à Deloyment Wizard. Use this wizard to deploy the Analysis Services database
  • Open Management Studio, log on Analysis Services, we should see Adventure Works DW is a valid AS database.
  • Now we can open a new query, start to write MDX.
Categories: SSAS
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: