Since we used the PowerPivot installation route, we can actually just take a shortcut and have the PowerPivot configuration wizard setup everything in the SharePoint farm for us. This can save a lot of time, and works fine for this kind of POC environment.


If I go to the Start menu and drill down to the SQL Server 2012/Configuration Tools folder, the first item in the list for me is the PowerPivot Configuration Tool. I’m going to run that.


It’s detected that nothing has been done yet, so it only gives me one option–”Configure or Repair PowerPivot for SharePoint”. I’ll click “OK” on that form.

As you can see this wizard is going to do a lot of things. The exclamation points tell us the wizard doesn’t think we’ve given it enough information yet, so I’m going to go ahead and enter my service account here. I only have one service account.

It already picked up the database server (the POWERPIVOT instance on this VM, which is called SHAREPOINT). I need to add a Passphrase as well. The Passphrase is used to add additional web front ends to the farm. I’m not planning to do that, but I still have to put in a passphrase.

Then if I want to use a random CA (Central Admin) port, I can leave what was entered. I like to use the same port every time I do an install so I don’t have to guess. I’m going to specify “2010″.


Once I’ve entered these fields I’ll click the “Validate” button to see if the wizard thinks I’ve put in everything I should. This looks good, so I’ll click the “Run” button, and confirm that I want to proceed.

At this point just let the automated process continue. This wizard is going to use PowerShell to configure the farm and setup the PowerPivot service, the Secure Store Service, etc. It does a lot of things we might otherwise do manually. This is a great shortcut when you’re putting together a proof- of-concept (POC) system.


When the wizard completes successfully, we’ll have a configured SharePoint Farm with PowerPivot and Excel Services. Let’s go ahead and check to see if the farm is working….exit the wizard.


I’ll start Central Admin to see the CA site is working, which will tell me SharePoint has been configured. I can see it is working.

The configuration wizard for PowerPivot also configured a default site collection. I’m going to see if that’s working as well. Here I can see it is working, and I have a PowerPivot gallery created for me. Of course there’s no data there yet.

If I go to Central Admin I can look at the service applications that have been created for me. I see PowerPivot, Excel Services and Secure Store. That’s a good start, but I also want to have SSRS, Power View and PerformancePoint. In the next lesson we’ll install the Reporting Services SharePoint Mode.

Leave a Reply

Your email address will not be published. Required fields are marked *