I would like to point out that this installation is actually pretty simple for a brand new BI environment. If you are new to the series, please click on one of the other blogs in the series to get up to speed. If not, continue on!
- SQL Server 2012 (RC0) Business Intelligence Configuration
- SQL Server 2012 (RC0) Installation and Configuration
- SharePoint 2010 Installation for SQL Server 2012 (RC0)
- Additional SSAS Instance Installations in SQL Server 2012 (RC0)
- SQL Server 2012 (RC0) PowerPivot for SharePoint 2010 Configuration
- SQL Server 2012 (RC0) SSRS Configuration in SharePoint Integrated Mode (including Power View) (Coming Soon)
- SSRS Alerting (Coming Soon)
- MDS (Coming Soon)
As stated earlier, the installation of SharePoint 2010 for us is actually quite simple. This is great for those that have spent a lot of time using the BI tools, but not a lot of time installing and configuring SharePoint 2010. This is not to say that no planning is needed, however, the installation and configuration of SSAS in PowerPivot mode will do most of the initial SharePoint configuration for us.
Note: Optionally, you can install and configure SharePoint yourself then add SSAS in PowerPivot integrated mode at a later date. Since this is configuration for a new server I am going to do it the easy way, and just let the PowerPivot configuration do all the heavy lifting for me.
To begin, open up the installation media. Enter your product key, agree to the license terms, choose the installation directory, and start the installation. That’s not too hard right?!?
The last key to the installation process is to make sure to uncheck the option to run the SharePoint configuration wizard at the end of the installation. Again, we are having the PowerPivot configuration wizard do this for us later in our server configuration so we don’t need to do it now.
Important: Before we can be done with the SharePoint installation, there is one more step that we can do to save us some time down the road. This would be to install SharePoint 2010 SP1. The new version of PowerPivot on SQL Server 2012 does require SP1, so if we don’t install it now, we will have to install it later. I firmly believe that installing the service pack before configuring the SharePoint farm is the way to go if that is an option for you.
You can find the SharePoint 2010 service pack here. Rather than just opening the file from the site, save the file locally on your server. Once downloaded, double click on the file to run the SP1 installation.
So we are done right? Nope! There is always one step that I forget. There is one more step needed to install the service pack. To do this, open a command prompt by right clicking on it, then running as Administrator. Once open, navigate to the following directory:
C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14BIN
Once there, run this command:
PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
Now you are all done with all the SP2010 installation steps.
Note: At this point we have installed quite a lot of new software onto our server including the OS itself, Office 2010, and SQL Server. For this reason I would recommend taking a break from the SQL 2012 installations to check for and install any Windows Updates that are available.