Steps A summary of what needs to be done is as follows: Install the sample AdventureWorks database onto SQL Server 2012 Follow these steps: 1.Click on SQL Server 2012 OLTP and you will be directed to the Downloads page for SQL Server 2012.Click on the AdventureWorksDW2012 Data File so that the AdventureWorksDW2012Data.mdf file is downloaded.
Copy the AdventureWorksDW2012Data.mdf file to the Microsoft SQL Server DATA folder as follows: C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATA 5. Launch Microsoft SQL Server Management Studio and select Server Type Database Engine. Click Connect. 7. Right-click Databases and click Attach. Click Add and select the AdventureWorksDW2012Data.mdf database. Click OK. 10. Remove the AdventureWorks2012Log.ldf file by clicking the Remove button. Click OK. Now the AdventureWorks database is attached. Install the sample AdventureWorks cube onto SQL Server 2012 Analysis Services Follow these steps: 1. Choose the AdventureWorks Multidimensional Models SQL Server 2012 download. Adventureworks Sample Database Zip Is DownloadThe result is that a file called AdventureWorks Multidimensional Models SQL Server 2012.zip is download. Put it in, for example, location C:AdventureWorks Cube. Unzip the AdventureWorks Multidimensional Models SQL Server 2012.zip file. Right-click on the AdventureWorks Multidimensional Models SQL Server 2012 folder and click on Properties. Uncheck the Read-only property and then click OK. A confirmation screen is shown to Apply changes to this folder, subfolders and files. Go into the Enterprise folder. Notice that there is a file called AdventureWorksDW2012Multidimensional-EE.sln. Double-click on the AdventureWorksDW2012Multidimensional-EE.sln file to open it in Visual Studio 2010. If prompted to enter the default environment settings for Visual Studio 2010, select Business Intelligence Settings. ![]() Open up the AdventureWorksDW2012.ds file by double-clicking on it. Click Edit the Connection string to launch the Connection Manager. Log on to the server by entering your credentials and select the AdventureWorksDW2012 database to connect to. Test the connection by clicking Test Connection. Assuming that the connection is successful, the following screen will be shown: 15. Click OK. 16. On the Data Source Designer page, click on the Impersonation tab. Then click OK. 17. Show the Deployment Progress window by selecting View - Show Deployment Progress. The Deployment Progress section is shown. Deploy the Adventureworks DW2012Multidimensiona-lEE multidimensional database. Right-click on Adventureworks DW2012Multidimensiona-lEE and then click Deploy. The Deployment Progress view will show the status of the deployment including whether or not the deployment was successful. Now if you look in SQL Server Management Studio, you will see that the cube is deployed. In SQL Server Management Studio, select File - Connect Object Explorer. After clicking Connect, you will now see that the AdventureWorksDW2012Multidimensional-EE analysis database is now shown.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |