Remove PowerPivot for SharePoint (PowerPivot Configuration Tool)

Uninstalling PowerPivot for SharePoint from a SharePoint farm is a multi-step process that includes using tools or script to remove features and solutions from SharePoint, followed by SQL Server Setup to remove program files and registry settings on a local computer.

This topic explains how to remove features and solutions using the PowerPivot Configuration Tool. Removing features and solutions is part of broader set of task that uninstall the software. Before removing features and solutions, review this topic to learn about steps that precede and follow this one: Uninstall PowerPivot for SharePoint.

Requirements for using the tool

You must be a farm administrator, a server administrator on the Analysis Services instance, and db_owner on the farm’s configuration database.

The tool can only be used with a SQL Server 2012 instance of PowerPivot for SharePoint. Do not use it with SQL Server 2008 R2 installations.

Verify that the SharePoint 2010 Administration service is running.

Run the PowerPivot Configuration Tool to remove features and solutions

Before you run SQL Server 2012 Setup to uninstall program files, you can run the PowerPivot Configuration Tool to remove features and solutions from the farm.

  1. On the Start menu, point to All Programs, click Microsoft SQL Server 2012 , click Configuration Tools, and then click PowerPivot Configuration Tool. Note that this tool is listed only when PowerPivot for SharePoint is installed on the local server.

  2. Select Remove Features, Services, Applications, and Solutions and then click OK.

  3. Optionally, expand the window to full size. You should see a button bar at the bottom of the window that includes Validate, Run, and Exit commands.

  4. Review each action in the task list to understand what each one does.

    In Remove PowerPivot Service Applications, you are given the option of deleting application data associated with the service application. The application data is a SQL Server database that was created with the service application for the purpose of storing data refresh schedules, database instance information, usage data, and other data used by PowerPivot for SharePoint. It does not store user files, such as PowerPivot workbooks. Unless you have a specific reason to keep the application data (for example, if you have data retention policies related to data refresh or data access) you can delete the application database without removing any files that were created or saved by SharePoint users.

    To delete the database, select Remove PowerPivot Service Applications and then select the Delete application data associated with this service application.

  5. Optionally, review detailed information in the Output tab or Script tab.

    The Output tab is a summary of the actions that will be performed by the tool. This information is saved in log files at C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\ConfigurationTool\Log.

    The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

  6. Click Validate to check whether each action is valid. If Validate is not available, it means that all of the actions are valid for your system.

  7. Click Run to perform all of the actions that are valid for this task. Run is available only after the validation check is passed. When you click Run, the following warning appears, reminding you that actions are processed in batch mode: “All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. Do you want to continue?”

  8. Click Yes to continue.

After the features and solutions are removed, continue with the remaining steps described in this topic: Uninstall PowerPivot for SharePoint.

Troubleshooting errors

Sometimes errors will occur that prevent the task from completing. You can view error information in the Parameters pane for each action.

For problems related to solution deployment or retraction, verify the SharePoint 2010 Administrator service is started. This service runs the timer jobs that trigger configuration changes in a farm. If the service is not running, solution deployment or retraction will fail. Persistent errors indicate that an existing deployment or retraction job is already in the queue and blocking further action from the configuration tool.

To find and remove a deployment or retraction job that is already in the queue, do the following:

  1. Start the SharePoint 2010 Management Shell as an administrator and then run the following command to view jobs in the queue:

    Stsadm –o enumdeployments
  2. Review existing deployments for the following information: Type is Retraction or Deployment, File is powerpivotwebapp.wsp or powerpivotfarm.wsp.

  3. For deployments or retractions related to PowerPivot solutions, copy the GUID value for JobId and then paste it into the following command (use the Mark, Copy, and Paste commands on the Shell’s Edit menu to copy the GUID):

    Stsadm –o canceldeployment –id “<GUID>”
  4. Retry the task in the configuration tool by clicking Validate followed by Run.

For all other errors, check the ULS logs. For more information, see View Log Files (PowerPivot for SharePoint).