SQL Server 2012 BI Environment in 12

are you fan of creating VMs? do you like to have your own environment signed by your name as your companion in developing Microsoft BI applications, creating POCs or even trying and learning some new stuff? I Love doing this very much… So I listed below the steps that you need to follow in order to have your own Environment ready.

so here’s the recipe that at the end you’ll end up having a VM with SQL server total installation with Analysis service both multidimensional Mode for your dashboard and KPIs and tabular mode for your new PowerView report, SharePoint with PowerPivot for SharePoint installed for your Self-Service BI.



1. Windows Server 2008 R2 SP1

2. SQL Server 2012

3. SharePoint Server 2010

4. SharePoint Server 2010 SP1

5. Microsoft Office 2010

6. PowerPivot for Excel



1. Create a New VM with HD of Size 200GB form Hyper-V manager

2. Install Windows Server 2008 R2 with SP1 (if the Windows version without SP1 then Install SP1 separately after finishing the installation).

3. Create a Internal Network connection adapter on Hyper-V. We’ll call it LoopBack Adapter and we’ll give it IP in the Host and Gateway to

4. In the VM assign a fixed IP to the Network Connection with and gateway

5. Open run and Type dcpromo to start creating a domain for your VM choose any name for example milkyway.local keep the rest default settings and after it finishes restart the machine and login with the domain administrator account.

6. in the Server Manager > Roles add the Application Server Role


6. Install SQL Server 2012 with all components (choose the analysis services instance to be Multidimensional).

7. Install SharePoint Server 2010 and don’t Configure it then Install SharePoint Server 2010 SP1.

8. Install a new instance from SQL Server and choose only the Analysis services, name the instance .\TABULAR and in the type of Analysis choose it as tabular mode.

9. Install the PowerPivot for Sharepoint (from the installation Pack of SQL Server 2012). Un-check the include Database engine option.

10. after installation finishes open the SQL Server 2012 > Configuration Tools > PowerPivot Configuration Tool put the domain administrator account for configuration and choose the default database instance then Validate, if validation went Run

11. Install Microsoft Office 2010 and after it install PowerPivot For Excel (make sure the same version either x64 or x86).

12. Install the reporting services Shared feature on the SharePoint using these steps.

a. open the Sharepoint 2010 management shell and type

      command> Install-SPRSService

      command> Install-SPRSServiceProxy

      command> get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance
(here’s a detailed info from this blogpost on Configuring SQL Server 2012 Reporting Services SharePoint 2010 Integration)

b. open SharePoint central administration > Application Management > Manage Service application > New > SQL Server Reporting Service Application. choose a name for it and database connection



P.S. you may also need from this screen to add PerformancePoint Service Application.


and We’re Done Smile Enjoy your VM. you may add your own spices to it ( silverlight, zoomit, … )

My original post on my website can be found here

Comments (1)

  1. PrissyLou says:

    Hi, Getting frequently updtaed article in webpage on recet activities is rare now and I got to gain certain like that fro your post. I used tio get like those here.


Skip to main content