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.