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.