kvmatomic.blogg.se

In Deployment screen change Server name from localhost to name of server where Analysis Services database should be deployed. In BIDS Choose menu option "Project" and then "Adventure Works DW Properties".If SQL Server Adventure Works DW database is installed not on the local machine, then after you open solution in BIDS (Business Intelligence Development Studio), double click on data source "Adventure Works.ds", click "Edit" on connection string and change Server name from localhost to your SQL Server name where Adventure Works DW database is installed.From the menu select "File"->"Open"->"Project/Solution"->navigate to the script folder (default c:\Program Files\Microsoft SQL Server\100\Tools\Samples) and then select sub-folders \AdventureWorks 2008 Analysis Services Project\enterprise and open file "Adventure Works.sln".Start SQL Server Business Intelligence Development Studio (BIDS).Start SQL Server Management Studio 2008 (SSMS 2008), connect to your SQL Server instance and confirm that you have database "AdventureWorksDW2008" installed on your instance.Click "Install" button and wait till setup will finish.At the very minimum you should select database "Adventure Works Data Warehouse 2008". Select databases that will be installed on your instance.By default location is c:\Program Files\Microsoft SQL Server\100\Tools\Samples Select location where you would like to install scripts.Select instance where you would like to install databases and select databases that you would like to install on that instance.

After accepting licence agreement you will get a "Database Selection" screen where you will be able to select databases that you would like to install on your machine. Execute file AdventureWorks2008_SR4.exe.