Uninstall PowerPivot for SharePoint

Prerequisites

You must be a farm administrator to uninstall SharePoint 2010.

You must be a SQL Server System Administrator to uninstall the Database Engine.

You must be an Analysis Services System Administrator to uninstall Analysis Services and PowerPivot for SharePoint.

Overview

SQL Server 2008 R2 Setup will uninstall most of the programs and features that it installed. It will not uninstall client libraries, data providers, or other software components that are part of redistribution. Such software might be legitimately used by other programs on the server, so Setup leaves these files alone even if it installed them.

Setup does not delete data files, databases, and libraries (such as PowerPivot Gallery) that are associated with PowerPivot for SharePoint. These files and items must be deleted manually.

In a SharePoint farm, services and applications that were activated by SQL Server Setup remain operational after PowerPivot for SharePoint is uninstalled. Both Excel Services and Secure Store Service, which are enabled and configured in a PowerPivot for SharePoint New Server installation, remain enabled and configured after you uninstall PowerPivot for SharePoint.

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.

1. 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.

   • How to: Delete PowerPivot Gallery

   • How to: Delete a Data Feed Library

2. Delete Excel workbooks or Reporting Services reports in other libraries that contain or reference PowerPivot data.

3. Remove any web part in a PerformancePoint dashboard that references PowerPivot data.

4. 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.

5. 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.

Uninstall: All Server Software (PowerPivot for SharePoint, SharePoint 2010, and Database Engine)

If you used the New Server installation option to deploy a PowerPivot for SharePoint server, SQL Server Setup installed and configured multiple server products. In a separate step, you might also have added Reporting Services configured for SharePoint integration to enable ad hoc reporting against published PowerPivot workbooks.

To remove all of the server products that were installed, you should remove them one at a time. It takes extra time to uninstall software this way, but it leaves you with a clean server that you can repurpose in other ways.

If you are uninstalling all PowerPivot servers in your farm, be sure to uninstall one server at a time to ensure that shared files and features are uninstalled correctly. Do not simultaneously uninstall multiple PowerPivot for SharePoint servers at once.

1. Remove PowerPivot for SharePoint.

   1. In Control Panel, click Programs, and then click Uninstall a program.

   2. Select Microsoft SQL Server 2008 R2 (64-bit).

   3. Click Uninstall/Change.

   4. Click Remove.

   5. In Setup Support Rules, click OK.

   6. In Select Instance, in Instance to remove features from, select PowerPivot.

   7. Click Next.

   8. In Select Features, select Analysis Services and Analysis Services SharePoint Integration options. Do not select any other features.

   9. Click Next.

   10. Click Next.

   11. Click Remove.

2. Uninstall the Microsoft SQL Server Reporting Services Add-in for SharePoint, if you enabled report server feature integration on SharePoint.

3. Remove Microsoft SharePoint Server 2010, again using the Uninstall option in Control Panel. A system reboot is required after the software is removed.

4. Remove Reporting Services if it is installed as a separate instance. Otherwise, if it is installed in the 'PowerPivot' named instance, you can remove it together with the SQL Server Database Engine in the next step.

5. Remove SQL Server Database Engine and any shared features that are currently installed. In the Select Instance page, select the 'PowerPivot' named instance. In the Select Features page, click Select All to remove all services that are part of the 'PowerPivot' instance, plus the shared features that are available to all instances.

6. Uninstall other software programs that were added by SQL Server:

   1. Microsoft SQL Server Compact 3.5 SP2

   2. Microsoft Visual Studio Tools for Applications 2.0

   3. Microsoft Visual Studio 2008 Shell (integrated mode)

   4. Microsoft SQL Server Analysis Services Management Objects

7. Move any data files that you want to keep, and then delete folders from \Program Files\Microsoft SQL Server.

8. Optionally, remove Windows roles and features that were enabled by SharePoint Setup or prerequisite installation programs.

   • Application Server role

   • Web Server (IIS) role

   • .NET Framework 3.5.1

   • Windows Identity Foundation

   • Microsoft SQL Server 2008 R2 Native Client.

   • Microsoft SQL Server 2008 Analysis Services ADOMD.NET.

   • Microsoft Sync Framework Runtime v 1.0

   • Microsoft Chart Controls for Microsoft .NET Framework 3.5

   • Microsoft Filter Pack 2.0

   • Microsoft Server Speech

   • Microsoft Silverlight 3.0

Uninstall: Only PowerPivot for SharePoint

Use the following instructions to remove just the PowerPivot for SharePoint software, leaving the rest of your SharePoint server unchanged.

1. In Control Panel, click Programs, and then click Uninstall a program.

2. Select Microsoft SQL Server 2008 R2 (64-bit).

3. Click Uninstall/Change.

4. Click Remove.

5. In Setup Support Rules, click OK.

6. In Select Instance, in Instance to remove features from, select PowerPivot.

7. Click Next.

8. In Select Features, select Analysis Services and Analysis Services SharePoint Integration options.

   

   If other features are in the list, such as Database Engine Services or Reporting Services, you can uninstall them also, but consider carefully whether to include the Database Engine in the uninstall operation. Uninstalling the Database Engine will disable your SharePoint farm if it is the farm's database server.

   If you installed shared features, such the management tools or Books Online, you can uninstall them if you no longer have other SQL Server components on the same computer. Otherwise, you should leave them installed so that you can continue to use those features with other components.

9. Click Next.

10. Click Next.

11. Click Remove.

Uninstall: A Subset of the PowerPivot Servers in Your Farm

Use the following instructions to remove one or more PowerPivot for SharePoint servers, while continuing to use other PowerPivot servers in the farm.

Using the remaining servers requires action on the part of your database administrator. The administrator must delete rows in the PowerPivot service application database that track instances of PowerPivot data that were loaded on the server that is no longer available. Uninstall does not remove instance data for you, so this step must be performed manually. Without this step, users will get a "Refresh failed for 'PowerPivot data' in the workbook" error when attempting to view or use PowerPivot data that was previously running on the server that you uninstalled.

1. In Control Panel, click Programs, and then click Uninstall a program.

2. Select Microsoft SQL Server 2008 R2 (64-bit).

3. Click Uninstall/Change.

4. Click Remove.

5. In Setup Support Rules, click OK.

6. In Select Instance, in Instance to remove features from, select PowerPivot.

7. Click Next.

8. In Select Features, select Analysis Services and Analysis Services SharePoint Integration options.

9. Click Next.

10. Click Next.

11. Click Remove.

12. On the database server, the database administer should use the following steps to clear the RedirectService.ReadAssignments table in the PowerPivot service application database:

    1. Using SQL Server Management Studio, connect to the database server.

    2. Enter the following T-SQL statement in a SQL query window, replacing the database placeholder name with the actual name of your service application database:

       USE DefaultPowerPivotServiceApplicationDB<placeholderGUID>;
       GO
       SELECT COUNT(*) AS BeforeTruncateCount 
       FROM RedirectService.ReadAssignments;
       GO
       TRUNCATE TABLE RedirectService.ReadAssignments;
       GO
       SELECT COUNT(*) AS AfterTruncateCount 
       FROM RedirectService.ReadAssignments;
       GO
       

    3. Repeat for other PowerPivot service application databases, if they exist.

13. On web front end computers that handle requests for PowerPivot data, run IISRESET from an administrator command line to pickup the changes to your farm configuration.

Verify Uninstall

1. In Central Administration, in Manage services on server, connect to the server on which you uninstalled PowerPivot for SharePoint.

2. Verify that SQL Server Analysis Services and SQL Server PowerPivot System Service no longer appear in the list.

3. After you uninstall the last PowerPivot for SharePoint server in the farm, do the following:

   1. In Application Management, in Manage service applications, verify that PowerPivot Service Application no longer appears in the list.

   2. 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.

   3. In Monitoring, in Configure diagnostic logging and in Configure usage and health data collection, verify that PowerPivot events and event categories no longer appear.

   4. In General Application Settings, verify that PowerPivot Management Dashboard is no longer on the page.

Post-Uninstall Checklist

Use the following list to remove software and files that were not deleted during uninstall.

1. Delete the following two registry keys. This step is necessary to avoid a configuration error if you reinstall or reconfigure SharePoint in the future. For more information, see SharePoint Configuration Error.

   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\ServiceProxies\Microsoft.AnalysisServices.Sharepoint.Integration.MidTierServiceProxy

   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\Services\Microsoft.AnalysisServices.Sharepoint.Integration.MidTierService

2. Delete the DefaultPowerPivotServiceApplicationDB database and log file from the farm’s database server. Use SQL Server Management Studio to connect to the farm’s database server and delete the database.

3. Delete all data files and subfolders from \Program Files\Microsoft SQL Server\MSAS10_50.PowerPivot, and then delete the folder. This step also deletes previously cached files in the DATA directory.

4. Delete all PowerPivot workbooks, documents, and libraries if you have not already done so.

   • How to: Delete PowerPivot Gallery

   • How to: Delete a Data Feed Library

5. 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.

6. In Control Panel, click Programs, and then click Uninstall a program. Uninstall any Analysis Services client libraries that are no longer used. Microsoft SQL Server 2008 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 2008 R2 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.

Preparing to Reinstall PowerPivot for SharePoint

You can reinstall PowerPivot server software on a computer that had a prior installation of PowerPivot for SharePoint. However, if the computer has an existing 'PowerPivot' named instance, it will block SQL Server Setup from installing a new instance of PowerPivot for SharePoint. In this scenario, you must uninstall any SQL Server components that are running as 'PowerPivot' and delete the program folders to free up the name so that it is available for a new PowerPivot for SharePoint installation.

If the Database Engine is running as 'PowerPivot', and it is the database server for the farm, you must move the SharePoint databases to another SQL Server instance before you uninstall it. For instructions on how to move SharePoint databases, refer to SharePoint product documentation. For more information, see Move All Databases on the Microsoft web site.

After you move the databases and verify your SharePoint server is operational, proceed with the following steps:

• Uninstall the Database Engine instance running as a 'PowerPivot' named instance.

• Delete the program folders for that instance.

• Uninstall any SQL Server 2008 R2 Analysis Services redistributable programs that you might have installed independently of SQL Server Setup. Specifically, if you downloaded and installed Analysis Services client libraries from the Feature Pack download page, you must uninstall those now. Otherwise, Setup will detect them and run a repair operation rather than performing a new installation of PowerPivot for SharePoint.

• Re-enable the premium site feature, as described in this article, How to re-enable the PremiumSite Feature in SQL Server 2008 R2.

  In addition, you can take precautionary steps to ensure that .NET assembly cache status about the Microsoft.AnalysisServices.SharePoint.Integration.dll does not get in the way of a successful reinstall. For more information, see Installation failure: “Could not load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’ and Error message when you install SQL Server 2008 R2 before you run the PreRequisiteInstaller.exe tool.

• Reinstall PowerPivot for SharePoint using the Existing Farm option. With this option, only Analysis Services will be installed as the PowerPivot named instance. For more information about how use the Existing Farm installation option, see Install PowerPivot for SharePoint on an Existing SharePoint Server.

Troubleshooting Uninstall Problems

Problems with uninstall typically surface when you attempt to reinstall the software later. In many cases, artifacts from a previous release prevent subsequent installation.

Review the Post-Uninstall Checklist to ensure all files and registry entries are removed.

If you are reinstalling using the New Server installation option that also configures SharePoint, verify that port 80 is available and that the expected SharePoint web site names are available (for example, SharePoint -80, SharePoint Central Administration v4, SharePoint Web Services). Remove any SharePoint databases. This allows Setup to recreate them using the default names.

For more troubleshooting tips, see the Troubleshooting PowerPivot for SharePoint Installation Problems page on the Microsoft TechNet WIKI.

The following table explains which features and components are uninstalled depending on your farm topology. This background information might be helpful to you if you are troubleshooting installation problems related to uninstall.

See Also

Tasks

Concepts