You will get the following dialogue box, change the target server property to your server name. Right click on the solution explorer, choose properties.Enter the server name and select the database in the "Connection Manager" wizard, Click on "Test Connection".In the "Data Source Designer" wizard, click on Edit.In the solution explorer, go to Data Sources and double click on "Adventure Works.ds".Solution Explorer looks like the following.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. 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. 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. 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. Go to the database installation location and select the solution.Go to File => Open => Project/Solution.Go to Start => All Programs => Microsoft SQL Server 2008 => SQL Server Business Intelligence Development Studio.Once the installation is completed, click on "Finish". "Installation Execution" wizard will pop up which will copy scripts and data files to the specified directory.In the "Database Selection" wizard, select the script install directory.In the "SQL Server 2008R2 SR1 Database Installer", accept the license terms and click on Next.Run the AdventureWorks2008R2_SR1.exe file.Deploy AdventureWorks Analysis Services Database.Install AdventureWorks Analysis Services Database.Here we will be seeing how to do the following In this article we will be seeing how to install AdventureWorks Analysis
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |