At this point we’ve installed SharePoint and PowerPivot, and we have an operational SharePoint site that has the default site collection that we could start using with PowerPivot at this point.
We’re going to add some more software, and that’s going to be the Reporting Services SharePoint mode. It’s not possible to add this at the same time that you use the PowerPivot installation wizard. So we have to run the SQL Install again in order to add the reporting services instance.
So we’ll run through the wizard again and go through the process until we get to the branch to select what kind of installation we want to do.
Here’s where we need to make a decision. We could add to the POWERPIVOT instance, but I’m not going to do that because I don’t want my Reporting Services instance to be called “POWERPIVOT”. I think that’d be confusing.
So I’m going to just go ahead and select the “New Installation” option. Again this will prompt me to enter my license key or specify a different edition. I’ll choose “Evaluation”. Then accept terms. This time I will not select PowerPivot for SharePoint. I’ll use the SQL Server Installation option.
For reporting services I need to choose (minimally) these two items: Reporting Services – SharePoint and the Reporting Services Add-in for SharePoint Products. The Reporting Services – SharePoint item is Reporting Services itself, which is basically the server services. The Add-in feature is basically the web parts that run the web front-end. If you neglect to choose this item, Reporting Services will be installed, but reports won’t render. You might find this confusing! I certainly would. So make sure you select both of these.
For this instance, which will be the default instance of SQL Server 2012, those are the only options that I’m going to select. Install only is the only option for SharePoint mode, because this is going to be a SharePoint service application which must be configured within Central Admin.
Finally, click “Install” to load the software.
Once the installation on the SQL side is complete, we can close out these wizards, go back to Central Admin, and refresh the browser. This will reload the Central Admin files into memory and get the site going. I’ll then proceed from here to configure Reporting Services SharePoint mode within Central Admin.