Uninstall PowerPivot for SharePoint
Uninstalling a PowerPivot for SharePoint installation is a multi-step operation that includes preparing for uninstall, removing features and solutions from the farm, and removing program files and registry settings.
This topic contains the following sections:
Prerequisites
Step 1: Pre-Uninstall Checklist
Step 2: Remove Features and Solutions from SharePoint
Step 3: Run SQL Server Setup to Remove Programs from the Local Computer
Step 4: Verify Uninstall
Step 5: Post-Uninstall Checklist
Prerequisites
You must be a SharePoint farm administrator or service application administrator to uninstall features and solutions in the farm.
You must be a SQL Server System Administrator if you are also uninstalling the Database Engine.
You must be an Analysis Services System Administrator to uninstall Analysis Services and PowerPivot for SharePoint.
Step 1: Pre-Uninstall Checklist
PowerPivot data access will be disabled once the software that supports query and data processing is removed from the farm. As a first step, you should preemptively delete files and libraries that will no longer be operational. This lets you address any questions or concerns about ‘missing data’ before you uninstall the software.
Delete all PowerPivot workbooks, documents, and libraries that are associated with a PowerPivot for SharePoint installation. Neither the libraries nor the documents will function once the software is uninstalled.
Delete Excel workbooks or Reporting Services reports in other libraries that contain or reference PowerPivot data.
Remove any web part in a PerformancePoint dashboard that references PowerPivot data.
Review SharePoint permissions on existing sites and libraries to determine whether you need to change them. Some PowerPivot data access scenarios, particularly secondary data access via a URL connection string to PowerPivot data in another workbook, require Read permissions, which is higher than the View permissions that are typically assigned to SharePoint users who only visit a site. If you no longer require Read permissions, you can reduce permissions accordingly.
Optionally, stop the services and wait several days before uninstalling the software. This step is not necessary for uninstall, but it gives you the option of temporarily resuming service while you work out any data migration or technology substitution issues that you might have missed.
Step 2: Remove Features and Solutions from SharePoint
To remove PowerPivot services and applications from SharePoint, you should use the PowerPivot Configuration Tool. Using the tool helps you avoid making mistakes or missing steps. For more information, see Remove PowerPivot for SharePoint (PowerPivot Configuration Tool).
Alternatively, you can use PowerShell to remove features and solutions from the farm. For more information, see PowerPivot Reference for SharePoint PowerShell.
Step 3: Run SQL Server Setup to Remove Programs from the Local Computer
Deleting program files requires that you run SQL Server Setup to uninstall the software. Uninstall removes both files and the registry entries that were created by Setup. You can use the Programs and Features page to uninstall the software. An installation of PowerPivot for SharePoint is part of a SQL Server installation.
You can uninstall part of an installation without impacting other SQL Server instances (or features in the same instance) that are already installed. For example, you can uninstall PowerPivot for SharePoint while leaving other components, such as Reporting Services or the Database Engine, installed.
Select Microsoft SQL Server 2012 (64-bit) from the program list.
Click Uninstall/Change.
Click Remove. This starts SQL Server Setup.
From Setup, you can select the PowerPivot instance, and then select Analysis Services and Analysis Services SharePoint Integration to remove just that feature, leaving everything else in place.
Step 4: Verify Uninstall
In Central Administration, in Manage services on server, connect to the server on which you uninstalled PowerPivot for SharePoint.
-
For SQL Server 2012 SP1 Verify that SQL Server PowerPivot System Service no longer appear in the list.
For SQL Server 2012 Verify that SQL Server Analysis Services and SQL Server PowerPivot System Service no longer appear in the list.
After you uninstall the last PowerPivot for SharePoint server in the farm, do the following:
In Application Management, in Manage service applications, verify that PowerPivot Service Application no longer appears in the list.
In System Settings, in Manage farm features, verify that PowerPivot Integration Feature is no longer on the page. In Manage farm solutions, verify that the PowerPivot solutions no longer appear on the page.
In Monitoring, in Configure diagnostic logging and in Configure usage and health data collection, verify that PowerPivot events and event categories no longer appear.
In General Application Settings, verify that PowerPivot Management Dashboard is no longer on the page.
Step 5: Post-Uninstall Checklist
Use the following list to remove software and files that were not deleted during uninstall.
Delete all data files and subfolders from \Program Files\Microsoft SQL Server\MSAS11.PowerPivot, and then delete the folder. This step also deletes previously cached files in the DATA directory.
Delete all PowerPivot workbooks, documents, and libraries if you have not already done so.
In Secure Store Service, delete any target applications that contain stored credentials used by PowerPivot for SharePoint. Some, but not all, entries in Secure Store Service are deleted when you uninstall PowerPivot for SharePoint. Target applications created for the PowerPivot unattended data refresh account plus any target applications you created for data refresh still exist and must be deleted manually.
In contrast, individual target applications that were auto-generated by the PowerPivot System Service are deleted automatically when PowerPivot is uninstalled.
In Control Panel, click Programs, and then click Uninstall a program. Uninstall any Analysis Services client libraries that are no longer used. Analysis Services ADOMD.NET and Microsoft SQL Server Analysis Management Objects are not removed when you uninstall PowerPivot for SharePoint. Because the libraries might be used by other programs that use Analysis Services data, SQL Server Setup does not uninstall them automatically. You must uninstall these client libraries individually if you no longer need them.
Do not uninstall the SQL Server Reporting Services SharePoint 2010 Add-in unless you are following troubleshooting or installation instructions that specifically direct you to uninstall it. The Reporting Services Add-in is used by Access Services. It is installed by the SharePoint Products Preparation tool and should remain on the system to support functionality required by SharePoint.
Do not uninstall the Analysis Services OLE DB provider. SharePoint installs the OLE DB provider as a prerequisite for Excel workbooks that connect to Analysis Services databases. PowerPivot for SharePoint installs a newer version, but this version is backwards compatible so you should leave it on the system to avoid data connection problems later.