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

By Danielle Arad - September 5, 2012

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!