Installation of PowerPivot is 2 step process. First we have to enable PowerPivot mode in SQL Server 2012. We need to setup a new database instance with PowerPivot. It will also enable Analysis services as SharePoint Integrate Mode.

Step 2 – Configuring PowerPivot Add-On

First we have to download the add-on. You can download from here.

Double Click to start installation.

Click next

Accept the agreement click next

If you have more than 1 server make sure you install SQL Server 2012 Feature Pack “ADOMD.NET” to all the servers in the farm.

Click Install

Click Finish.

Configure PowerPivot using PowerPivot Configuration

Press Start and type PowerPivot

Click on PowerPivot for SharePoint 2013 Configuration.

Click OK

Wait for validation to complete.

Confirm the PowerPivot SQL Instance Name

To confirm the Database server. Open SQL Server Management Studio and click on Server name dropdown and “Browse for more”

Expand Database Engine  Click on PowerPivot SQL Instance and click OK. Now Copy the server name. Click Connect to confirm that you are able to login.

Enter the password for Default Account

Paste the Instance Name

Enter passphrase for future addition to PowerPivot Farm.

Enter PowerPivot

Make sure there are no errors then Click Run then Yes.

Click Exit on PP Configuration Tool.

Open Central Administrator  Manage Service Application

You will find PowerPivot, Excel Services and Secure Store Service application which I never had.

End of Part 2.