PowerPivot Installation for SharePoint 2013

Installing PowerPivot

1. Login to the server where you want install PowerPivot. In this case I initially installed on one of the Central Administration server . Login to the server as the Setup account (domain\s_sp_setup)

2. Copy the SQL Install files on to the server where you want to install PowerPivot in your farm.(\\SQL Server\Enterprise Edition\SQL Server 2012 EE with SP1)

3. Click on setup.exe

4. Select Installation on the left side of the SQL Server Installation Center.

5. Select New SQL Server stand-alone installation or add features to an existing installation.

6. The below screen comes up saying all passed. Click View detailed report to see the details. Click OK.

7. Click Next

8. Select I accept the license and Click Next.

9. Uncheck the Include SQL Server product updates. Click Next.

10. Click OK and proceed.

11. Click Next.

12. Choose SQL Server PowerPivot for SharePoint. Uncheck the below option and click Next.

13. Click Next

14. Click Next

15. Keep the instance as POWERPIVOT. Click Next

16. Click Next

17. Using domain\s_sp_sql as the account here. [I wanted to have separate account for PowerPivot services] Click Next. Use the same account for one more installation of Analysis server on the same farm.

18. Add the s_sp_setup by clicking Add Current User. Click Next. Both s_sp_sql and s_sp_setup has same level of permissions. But s_sp_sql will run the SSAS service.

19. Click Next.

20. Click Next

21. Click Install.

Progress is shown below

22. Click OK

23. Click Close.

24. Go to services.msc. You will see SQL Server Analysis Services (POWERPIVOT) running under SQL Account [domain\s_sp_sql]. Restart the machine.

This post is continued here - PowerPivot Configurationfor SharePoint 2013