Alright, this is the continuation of my previous article “How to add SQL Server 2012 PowerPivot to the Excel Services in SharePoint 2013” and in this article we will go ahead and see the step by step approach to run the PowerPivot for SharePoint 2013 Configuration Wizard and also I’ll explain how to resolve the configuration errors. Let’s go ahead
Please follow the below steps to run the PowerPivot for SharePoint configuration wizard.
Step 1: Open up the PowerPivot for SharePoint 2013 Configuration application, you also notice same identical icon for PowerPivot Configuration Tool, but we do not want that.
Step 2: Configuration wizard will pop up and it has the option “Configure or Repair PowerPivot for SharePoint”. This the only option we have right now because we haven’t run this already. Click OK
Step 3: Now the new window will open and it will be having too many levels to validate. The green flags and warning signs. We need to concern on the warning signs, because we need to change them to green flag too. Once everything is fine, we will go ahead and validate all and then we will run the wizard.
Step 4: Go to the top level and provide the following values,
a) Default Account Username (I’ve provided Install account, you can change it if u want to)
b) Default Account Password
c) Database Server (we installed PowerPivot on our SharePoint Server, but sill we need to point to our SQL Server – Because although the PowerPivot instance is on our SharePoint Server, we want PowerPivot for SharePoint to build the database on our SQL Server).
d) Passphrase – Add it, so that we can add other servers to our farm later.
Once we done this, you notice that there won’t be any warning sign. Now we could validate, but we need to validate every single time when we change one of these. So we are going to validate at the end.
Step 5: Go to Create PowerPivot Service Application, we don’t have to create the PowerPivot Service application by going to SharePoint Central Administration, because this wizard is going to do it for us. But we have the parameters like Service name, Database Server and Database name that we can change.
Step 6: In Deploy Web Application Solution, here we’re going to go ahead and tell it which web application we want PowerPivot to work with.
You may want this to work on all of the web application. At that time, all we can do is assign it to one and you can use Central Administration to select an application from a list, like it says in the above context.
Step 7: Now we want to activate PowerPivot Feature in a site collection. So, click on Activate PowerPivot Feature in a Site Collection in left navigate and choose the site collection.
Step 8: Go to Create Unattended Account for DataRefresh because there’s nothing to do with above titles. Here, you can edit
a) Target Application ID
b) Friendly Name for Target Application
c) Unattended Account User Name (Here I’m not using install account, instead I gave another account – remember you can give any account according to your organization procedures and policies)
d) Unattended Account Password
e) Site URL (which we want this to work for)
After everything is done, it’s time to go ahead and click on Validate
Step 9: Once the validations are successful, click on Run and click on Yes for the below warning message.
It will take 15 steps to complete the process and it takes few minutes.
After successful configuration, you can find PowerPivot Service application in your Central Admin.
Error Handling
If you find an error during Configuration Run like below image, then go ahead and open up your SQL Server Management Studio -> go to content database of the selected web application -> under Security add User account which you used in Step 4 and provide SPDataAccess role membership.
And then come back to PowerPivot Configuration Wizard, click on Validate and Run.
Thank you for reading.
Happy Coding
Ahamed
Leave a comment