Step 1 Get the Binaries: SQL Server 2012 RTM, Windows Server 2008 R2, Sharepoint 2010 SP1 x64 Setup a VM: Check the System Requirements and configure the VM. And then Install Windows Server 2008 R2 x64 SP1 (and updates) |
Step 2 Add Server Roles: Application Server, File Services, Web Server Change Server Name to a friendly Name |
Step 3 At this stage, I cloned the Virtual Machine. And the following steps will be performed on the cloned (copied) virtual Machine. Thanks for the tip that I found here. The benefit of cloning is that you have a Windows Server 2008 R2 VM Template that you can use in Future. |
Step 4 On the cloned VM, run dcpromo.exe. This will make your server the Domain Controller and it will install ADDS binaries if they are not installed prior to running dcpromo.exe |
Step 5 Install Sharepoint per-requisites Install Sharepoint 2010 SP1 Note: Do NOT run the SharePoint configuration wizard |
Step 6 Run SQL server setup to Install “SQL Server PowerPivot for SharePoint”: ![]() Post-Installation: Launch the PowerPivot configuration tool to configure the server ![]() |
Step 7 perform a NEW installation of SQL Server Analysis Services Mode: Tabular |
Step 8 perform a NEW installation of SQL Server Analysis Services Mode: Multi-Dimensional |
Step 9 Verifying Reporting Services Installed in Sharepoint Mode. Tutorial here. Also Extend the Document Libraries to include BISM connections.[Read Follow up Blog Post: How to extend document library to connect to Tabular Model to create Power View reports ] |
Step 10 At this point, I installed and ran the SQL Server Training Kit 2012. It will list various “Missing” softwares like office, silverlight and also it will help you install sample databases. It’s a nice “shortcut” to make sure that you a “complete” sharepoint BI dev Environment ![]() |
Resources that I refer to for configuration Details:
1) SQL Shorts Video to configure SharePoint BI environment
2) Getting up and running with SQL Server Denali for Business Intelligence (Crescent and PowerPivot in CTP3)
3) Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint
That’s about it for this post. I’ll refer to this post whenever I have to setup my SharePoint BI Dev Environment. And if you are in the same position, then i hope the Bird’s eye view and the resources listed are helpful to you as well.
Thanks for the bird’s eye view..
You’re welcome!