22 March, 2012

VMware image with Sharepoint 2010, MSSQL 2012, SSRS, Performance Point and PowerPivot

This is how you can install a VMware Image with Windows 2008 r2, SharePoint 2010 and Microsoft SQL Server 2012 Denali.
I will also show you how you can configure SSRS, Performance Point and PowerPivot.
At first i tried to install this without a domain, and got everything working except PowerPivot.
At present time there is no workarounds for getting PowerPivot to run in a non domain environment.
Bummer, so i had to scrap it and start over with a domain.
Anyway installing a domain is pretty easy, so just live it and use a domain in your SharePoint playground.
It just makes your life so much easyer.

Sorry no screenshots, if there are parts you don't understand please contact me.

I spent a couple of days doing this, so maybe someone will find this useful.

Install windows

  1. Install VMware Workstation.
  2. Install Windows 2008 R2 With SP1 with username dev.
  3. Change computername to DevServer.
  4. Turn off the Firewall.
  5. Turn off UAC.
  6. Turn off IE ESC (Server manager down on the right).
  7. Add server roles: Web Server (IIS) and Application Server.
  8. Run windows update over and over again, until the green checkmark of delight appears. (Microsoft PLEASE, 2012 and this is still not automated in any way) .
  9. Power off the VM, and take a snapshot. VMware can only clone snapshots taken during power off (just a little tip if you need to clone it in a later life).

Install the domain controller

  1. Click Start, then run.
  2. Type in dcpromo and hit enter.
  3. Don't check use advanced mode installation.
  4. Select create a new domain in a new forest.
  5. FQDN of the forest root domain: xtrm.local or whatever.
  6. Forest functional level, just select windows 2008 r2.
  7. Select additional options for this domain controller, make sure DNS server is selected.
  8. Change to static IP in the IPV4 settings of your network card.
  9. For example IP: 10.10.10.1, Subnet mask 255.255.255.240.
  10. Continue the wizard: Select no, i will assign static IP addresses to all physical network adapters.
  11. A delegation for this DNS server could not be created. Click Yes.
  12. Location for Database, Log Files ans SYSVOL, just leave the defaults.
  13. Directory services restore mode administrator password: Use a strong password.
  14. Summary, click next, click Finish, and reboot.
  15. Switch back to dhcp, obtain ip address and dns automatically because of internet access through the VM.
  16. Now start Active Directory Users and Computers.
  17. Create 3 new users: sqladmin, spadmin, spfarm. Use same password, user cannot change password, password never expires.
  18. Add spadmin to the Domain Admins group.
  19. Reboot, and we are done with setting up the domain.

Install Microsoft Sql Server 2012

  1. When installing MSSQL 2012 Denali, make sure you install these options: Reporting Services - Native, Reporting Services - SharePoint, Reporting Services Add-in for SharePoint Products.
  2. In other words, select all features except the replay controller / client.
  3. Install a sql instance named SharePoint.
  4. Run all services with the xtrm\sqladmin user.
  5. Add dev, sqladmin, spadmin and spfarm user to the sql server / analysis services administrator group.
  6. Install and Reboot.
  7. Microsoft SQL Server 2012 is now up and running.

Install SharePoint 2010

  1. Login as spadmin, IMPORTANT !.
  2. Install SharePoint 2010 Prerequisites.
  3. Start the SharePoint 2010 server install.
  4. Wait until done.
  5. Run the SharePoint Products Configuration Wizard (Started automatically).
  6. Select Create a new server farm.
  7. Database server: DevServer\SharePoint
  8. Database name: SharePoint_Config
  9. Database Access account: xtrm\spfarm
  10. Passphrase: Enter a strong password.
  11. Force port number for SharePoint Central Administration.
  12. Select NTLM.
  13. Finish the wizard.
  14. Start SharePoint Central Administration,, configure your SharePoint farm (If not automatically started).
  15. Service account: Use existing xtrm\spfarm.
  16. Create a top level site, Team Site or whatever.
  17. SharePoint 2010 is now up and running in a farm on Microsoft SQL Server 2012.

Configure Reporting Services in SharePoint 2010

  1. Start SharePoint Central Administration.
  2. Click on General Application Settings.
  3. Under SQL Server Reporting Services, click on Reporting services integration.
  4. DON'T bother, because this is for SQL Server 2008 /2008 R2 only.
  5. This is how you integrate against SQL Server 2012:
  6. Start SharePoint 2010 Management Shell, right click and do a run as administrator. IMPORTANT !
  7. Type in: Install-SPRSService
  8. Type in: Install-SPRSServiceProxy
  9. Type in: get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance
  10. Now go back to SharePoint Central Administration.
  11. Click on System Settings, Manage services on server.
  12. Then you will see a service named: SQL Server Reporting Services Service with status Started.
  13. Goto Application management, Service Applications, Manage Service Applications.
  14. Select New then SQL Server Reporting Services Service Application.
  15. Name: SSRSApp, New app pool: SSRSAppPool, App pool account: xtrm\spfarm.
  16. Select windows authentication, select web application association: SharePoint 80.
  17. And we are done with SSRS integration against SharePoint 2010.

Configure Performance Point in SharePoint 2012

  1. Just make sure PerformancePoint Service is started in System Settings, Manage Services on Server.
  2. And that the Performance Point Service application has been created under Application Management, Manage Service Applications.

Configure PowerPivot in SharePoint 2010

  1. Login as spadmin.
  2. PowerPivot is a separate install, so first we need to install it.
  3. Run Microsoft Sql Server Setup.
  4. Add features to an existing installation.
  5. Next screen, you need to select Perform a New installation of Sql Server 2012.
  6. Then select Sql Server PowerPivot for SharePoint, do not select add database instance.
  7. It will default to named instance PowerPivot.
  8. Run the Sql Server Analysis Services as the xtrm\sqladmin account.
  9. Add dev, spadmin, spfarm and sqladmin as administrators.
  10. Finish the wizard and it will be installed.
  11. Start the PowerPivot Configuration Tool.
  12. Select Configure or Repair PowerPivot For SharePoint.
  13. Default Account: xtrm\spfarm
  14. Database Server: devserver\SharePoint
  15. Enter SharePoint passphrase.
  16. Click on Register Sql Server Analysis Services (PowerPivot) on local server and enter password for sqladmin user.
  17. Click Validate, then Run.
  18. Click yes on the confirm messagebox.
  19. And wait until it succeeds.
  20. Start SharePoint Central Administration
  21. If you look at System, Services On Server, you now have a new service named: SQL Server PowerPivot System Service.
  22. Goto Application Management, Manage Service Applications.
  23. You will have a new Service Application named: Default PowerPivot Service Application.
  24. Now there are 2 farm solutions that has been deployed in the farm.
  25. To view them goto System Settings, Manage farm solutions.
  26. PowerPivotfarm.wsp is globally deployed.
  27. PowerPivotWebApp.wsp is deployed to each web app.
  28. So if you create a new webapp, then you need to deploy this solution to the new webapp.

Great, finally everything is installed and configured.
Later i will write a post about how you actually use what you have installed:
  • SSRS both Native and SharePoint.
  • Performance Point.
  • PowerPivot.

A final tip: ALWAYS run IE and SharePoint Management Console as administrator.
(Right click and run as administrator). If you don't do this there will be a lot of menu options in
SharePoint Central Administration that will be missing.
And the scripts will fail with some cryptic errors.
If you find any errors above, unnecessary steps or other ways to improve the sequence,
please let me know.

2 comments:

  1. Hello sir you know people like you are helping community so much really good clear instructions thank you very much :)

    ReplyDelete