Lydia Bronze

How to install SharePoint Server 2013 preview with SQL Server 2012 SP1 CTP3 SSRS, SSAS, and PowerPivot and PowerView

September 5th, 2012 | Author: | Filed under: Dev / Test, SharePoint | Tags: , , , , , , , ,


SQL Server 2012 SP1 CTP3 has been released a while ago and those are great news for me and those who would like to test Business Intelligence capabilities available in SharePoint Server 2013 and Office 2013 previews.  Like I normally do, when i’m building no templates I record the process.  And the interesting ones become blog posts.  As always you can save yourself the time, by grabbing this permalink where i’ve already done the work!

I’ve decided to build a single server environment including SharePoint Server 2013, SQL Server 2012 SP1 CTP3 with PowerPivot, PowerView, SSRS (Native Mode and SharePoint Mode), SSAS (Multidimensional and Data Mining Mode, PowerPivot for SharePoint, Tabular Mode) and PowerPivot features for Excel 2013. In this post I will walk you through the installation process of those components.

  • Install and configure a Domain Controller on Windows Server 2008 R2/2012.
  • Create user accounts for the SharePoint, SQL and PowerPivot Services. Navigate to the Active Directory Users and Computers. Click on Start -> Administrative tools -> Active Directory users and computers. Create the following Service accounts: SPAdmin (SharePoint Admin Account), SPFarm (SharePoint Farm account), SQLSvc (SQL Server database engine account), SSAS (SQL Server Analysis Services Account), SSRS (SQL Server Reporting Services Account)
  • Note: In case you are installing an environment on a single server, there is no ‘Local Administrators’ group on a domain controller, so the service accounts should be added to ‘Domain Administrators’ group. If you are installing a multi server environment adding your service accounts to local ‘Administrators’ group is sufficient.
  • Our next step is installing SharePoint Server 2013 Preview (Perform steps 1-3). Before starting the installation of SharePoint, I recommend reading the following article about hardware and software requirements. After SharePoint Server 2013 installation finishes please do not run the SharePoint products configuration wizard yet.
  • Let’s start the installation of SQL Server 2012 SP1 CTP3 Standard Edition. This early CTP3 version of the SP1 release is intended ONLY for those users who are testing Business Intelligence capabilities available in Office 2013 and SharePoint 2013 public preview. Download this SQL Server version and click on the install file to open the SQL Server Installation Center.
  • The installation will check setup support rules. Please take care of any warnings or issues before continuing with the setup process.                  
  • On the Setup Role screen, select the SQL Server Feature Installation option.                                                                                                                                   
  • We are installing a stand-alone server, select all features available in the Feature Selection screen.                                                                                                                                                                              
  • The installation will check installations rules.                                                                                                                                                                                                  
  • Specify a name for the Database Engine instance and the Instance ID, and click on Next.                                                                                                          
  • Define which accounts will be used in order to run each of the SQL services. Use the service accounts that have been created earlier.                                                   
  • In the Database engine configuration, select the Windows authentication mode and add user permissions.                                                                      
  • Our next step is configuration of Analysis Services. We are going to install all three instances of SSAS (Multidimensional, Tabular and PowerPivot), we will first install the Multidimensional and Data Mining Mode.
  • In the reporting services configuration screen, choose to install and configure SSRS in native mode and install only option in SharePoint integrated mode and click on Next.  
  • Specify which users have permissions for the Distributed Replay Controller service and click on Next.
  • Specify controller machine name and directory locations and click on next.
  • The installation wizard will check the Installation configuration rules.                                                                                                                                                
  • Wait for the installation process to finish.                                                                                                                                                                                                         
  • After we have installed and configured one instance of SSAS in Multidimensional and Data Mining Mode, we can continue to install and configuring the other two types of SSAS available for installation in SQL 2012. The first is SSAS in Tabular Mode, and the second is PowerPivot for SharePoint Integrated Mode.
  • Click on the SQL Server install file to open the SQL Server Installation Center. Continue through the Setup Support Rules until you are asked to choose the installation type. Choose to perform a new installation of SQL Server 2012. In the Setup Role screen select the SQL Server feature installation option.                                                                                                                                   
  •  In the feature Selection screen, choose the Analysis Services feature and click on Next.                                                                                                   
  • Specify a name for your SSAS Tabular instance and click on Next.                                                                                                                                                                            
  • Define SQL Server Analysis Services service account and click on Next.
  • In the Analysis Services configuration screen choose the Tabular Mode option, add an administrative user account, and click on Next. 
  • Wait for the installation process to finish successfully.
  • We are now going to install SSAS for PowerPivot for SharePoint. I will skip over few steps as they are the same as in the Tabular Mode installation. On the Setup Role screen select the SQL Server PowerPivot for SharePoint Installation option and click on Next (Since we just installed a new instance of SQL Server Relational Engine earlier, you should uncheck this option.)
  • Notice that in the feature selection screen the features have been selected for you. Click on next.                                                                                         
  • Name your instance and instance ID as ‘PowerPivot‘.                                                                                                                                                                       
  • Specify SQL Server Analysis Services service account and click on Next. Continue with the installation process, and wait until the installation completes successfully. 
  • Install the following SQL Server 2012 SP1 CTP3 PowerPivot feature pack.
  • Important! Before we start configuring PowerPivot for SharePoint Server 2013 Preview using the PowerPivot for SharePoint 2013 Configuration tool we have to run the SharePoint products configuration wizard (Review Steps 4-8). Normally the PowerPivot for SharePoint 2013 Configuration tool could configure SharePoint Central Administration for you but it does not work quite well and returned some errors. I suggest running the SharePoint products configuration wizard first (Do not create any site collections, just configure the Central Administration) and then the run PowerPivot for SharePoint 2013 Configuration tool.
  • Welcome to the PowerPivot for SharePoint 2013 Configuration tool. Click on Configure or Repair PowerPivot for SharePoint and OK.                          
  • You should go over all tasks listed in the wizard and make sure that the credentials of the service accounts and other properties are configured correctly.
  • When you’re done click on “Validate”. If the validation succeeded click on “Run”. If the validation did not complete successfully, correct the gaps and validate again.  
  • Exit the wizard after it finishes running.                                                                                                                                                                                                                                             

That’s it! We’re done with the installation process of SharePoint Server 2013 preview with BI Stack. There are few more configuration nuances you should take care of such as creating the relevant web applications and customizing  your SharePoint sites. Start exploring Business Intelligence capabilities that SharePoint Server 2013 has to offer!

Related posts:

lb32Step-by-Step Guide to Installing SharePoint with SQL 2012 PowerPivot, PowerView, and Reporting Services 05 - Setup Support RulesHow to Setup SSRS in SharePoint Integrated Mode image_thumb.pngHow to install and configure workflow infrastructure in SharePoint 2013
About the author:
Lydia Bronze ( @LydiBee ) , Cloud Content Architect at CloudShare, is an experienced technologist with a diverse and deep background in infrastructure technologies, information security and technical training. Lydia's proven ability to architect, implement and provide solutions for advanced infrastructures using Microsoft and Open Source technologies makes her an invaluable asset to the team. She brings technical experience from a variety of industries, including the Defense and Finance sectors. In addition, Lydia has extensive SharePoint experience and has implemented corporate environments as well as custom SharePoint solutions for organizations of all sizes. Lydia is continuously seeking new challenges that will allow her to utilize her technical abilities.

  • Pingback: SharePoint 2013: Integración con SSRS 2012 (I)! - Blog del CIIN

  • Pingback: SharePoint 2013: Integración con SSRS 2012 (I)! « Pasión por la tecnología…

  • Jay

    Exactly what I was looking for. Thank you.

    • Lydia Bronze

      Thank you Jay,
      I am glad you found it helpful!

      • Bharath

        Hi Lyndia,

        I am trying to create a content database for a Local (On Premises) Sharepoint WebApp. in SQL Server Azure Database server. But I am not able to achieve it. Is it possible to do so?

  • Rohit Sankhe

    Really a good article on installation of SharePoint 2013 preview….
    Great work … will post the link on our company forum for all to read…
    btw … Even after going through so many setup/installations I still dont get comfort on creation and assignment of Service Accounts in SQL in Server Farm environment.

    • Lydia Bronze

      Rohit,
      Thank you!
      If you have any questions regarding creation and assignment of SQL service accounts feel free to ask.

  • Daniel

    Thanks for your great work on this. What is the best way to split this into a separate SQL server and SP server so I can distribute the resources? Or would I have to build from scratch?

    • Lydia Bronze

      Hi Daniel,

      I would like to understand your question better. Are you asking what is the best way to split the resources? Or where should you install what?

  • martin woodger

    I am following this procedure with Sharepoint 2013 Enterprise and SQL Server 2012 BI but find when I add the Analysis services instance for PowerPivot the process fails before reaching Instance Configuration stating that SharePoint “2010″ has not been installed. Although it passes on three other checks for SharePoint. I have used the same procedure successfully with SharePoint 2010 Enterprise and SQL Server 2012 BI. Any suggestions?

  • martin woodger
  • Sunil

    I am getting error on running the powerpivot wizard as it works only for 2010. I installed the SQL 2012 SP1 only. Appreciate your help

    • Lydia Bronze

      Sunil,
      What does the error say?

  • Pingback: Sharepoint 2013: Single server deployment on Windows Server 2012 + Claim-based authentication (Cloud simulation) « IT Consultant Everyday Notes

  • Azad

    Hi Lydia,

    Could you help me please. I am trying to download and install SQL Server 2012 SP1 CTP3 or CTP4 version from the link that you have provided, but I couldn’t find the download link. I got the following message while I hit the link-”We are sorry, the page you requested cannot be found”.http://www.microsoft.com/en-us/download/details.aspx?id=30375. I have seen another Blog(http://www.system-center.fr/?tag=ctp4) that CTP4 is now released and when I hit the link,(http://www.microsoft.com/en-us/download/details.aspx?id=34700) got same error.

    Currently trying to install SharePoint-2013 on my Machine and require to install SQL server-2012 under Windows server-2012, But the normal SQL server-2012 is’t running to install. It the following error:2 The operating system on this machine does’t meet minimum requirements for SQL server -2012.” Though I have set-up roles on windows server-2012 .Net framework 3.5, 4.0 and other options.

    Appreciate your kind help.

    Regard

    Azad

    • Lydia Bronze

      Hi Azad,

      Thank you for pointing that out. Although I don’t see anything official, my guess is that Microsoft don’t enable CTP3 and CTP4 download anymore. You can download SP1 for SQL Server 2012 here:
      http://www.microsoft.com/en-us/download/details.aspx?id=35575

      Regarding the minimum requirements of SQL Server 2012, I would check the installation log file to see what interrupts the installation process. It could also be a hardware issue.

  • Geek12

    Great Article. Thanks Lydia!

    • Lydia Bronze

      Thanks!

  • EricT

    Hi Lydia,

    I have been following several articles of yours for a fews month already. They are very clear and thanks for that.
    The installation process seems straightforward when SharePoint and SQL Server are in the same box. Howerver I have not found information about where to install my Tabular and PowerPivot SQL instances in the case where I have 2 servers.

    In my scenario, I am using two server, one for SQL Server and one for SharePoint.
    I have installed MultiDimensional instance on my SQL Server (without SharePoint).
    ==> Where should I install the Tabular instance ? On my SQL Server or SP Server ?
    ==> and PowerPivot instance ?

    If I install PowerPivot instance on my SP Server, do I have to “create a new farm” when running the SharePoint configuration wizard ?

    Thanks for the clarification
    Eric

    • Lydia Bronze

      Hi Eric,

      Thank you.

      In case you are installing a Multi-Server Installation of PowerPivot for SharePoint this is what you need to do:
      Install your SharePoint and database server and then install PowerPivot for SharePoint on the SharePoint server.

      For more information you can follow the steps here: http://technet.microsoft.com/en-us/library/ee210708.aspx

      Please pay attantion to section 10 in the Technet article. As you already have a database server and you don’t need to create a new instance of the Database engine to your installation please uncheck this option.

      The Tabular instance should be installed on your SQL Server.

      Hope this helps. If you have more questions feel free to ask.

      • Eric

        Hi Lydia, thanks for your reply. So is it correct if I do this:
        1 – SQL Server Machine:
        a) Install SQL Server Database Engine only
        b) Install SQL Server Analysis Service Tabular Mode

        2 – SP Machine:
        a) Install SharePoint Server 2013
        b) Install SQL Server PowerPivot Instance without Database
        c) Install SQL Server Reporting Services SharePoint Add-in
        Is that correct or am I missing a step ?

        3 – Run SP Config Wizard (Point the DB to the SQL Server Machine)

        4 – Run PowerPivot Config Tool for SP 2013

        Do I have to install:
        - Analysis Services Multidimensional Mode on the SQL Server Machine ?
        - PowerPivot spPowerPivot.msi package ?

        Thank you
        Eric

  • http://www.facebook.com/john.denver.73 John Denver

    I keep receiving this error message. How do I obtain an enterprise version of SharePoint 2013 preview?
    If the picture doesn’t show up it says:
    “PowerPivot for SharePoint 2013 Configuration is missing prerequisites: an unsupported SharePoint version was detected. SharePoint 2013 Enterprise edition is required…. “

    • http://www.facebook.com/john.denver.73 John Denver

      I checked the Upgrade and Migration and it seems as though I do have an Enterprise version (dont know why I didnt think of that sooner). I have installed on windows server 2012 and 2008 r2, using two different SQL BI editions on both and still am recieving this error message. I am assuming the issue is with my SharePoint copy but if I configure normally (minus BI) everything works fine.

      • http://www.facebook.com/john.denver.73 John Denver

        I fixed it. Both copies of SQL I had were bad I suppose because I redownloaded it and everything is working.

        • Francis

          I am getting the same message. I am guessing that it is a “generic” message and that “no enterprise version” isn’t really the issue (I have the enterprise version installed). I am also using SQL Server 2012 SP1 Enterprise as well, so that isn’t the issue.

          Anyone have any ideas where to look to find the “real” issue?

  • Pingback: SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine | James Serra's Blog