1. Point to Start, click Administrative Tools, and then click Services. Double-click SQL Server Analysis Services (PowerPivot). Click Log On, and then enter the new password for the account.

2. In Central Administration, in the Security section, click Configure managed accounts.

3. Click Edit to change a specific account.

4. Select Change password now.

5. Select Set account password to new value. All services that run under the managed account will use the updated credentials.

1. In Central Administration, in the Security section, click Configure managed accounts.

2. Click Edit to change a specific account.

3. Select Change password now.

4. Select Set account password to new value. All services that run under the managed account will use the updated credentials.

1. In Central Administration, in the Security section, click Configure service accounts.

2. Select Windows Service - SQL Server Analysis Services to change the Analysis Services service account

   Select Service Application Pool - SharePoint Web Services System to change the application pool identity of the default PowerPivot service application. If PowerPivot for SharePoint was configured automatically by Setup, the service uses the existing service application pool. Setup registers the service as Default PowerPivot Service Application (PowerPivot Service Application).

   If the service was configured manually by a SharePoint administrator, the service most likely has its own service application pool.

3. In Select an account for this service, choose an existing managed account or create a new one. The account must be a domain user account.

4. Click OK.

1. In Central Administration, in Application Management, click Manage service applications.

2. Select, but do not click, the PowerPivot service application. Clicking on the application name opens the PowerPivot Management Dashboard, which does not provide a link to the properties page that specifies the application pool. You can click the empty white space in the row, or click on type name, to select the PowerPivot service application.

3. Click Properties on the ribbon.

4. Select Create a new application pool. Provide a name for the application pool and specify a managed account for its identity.

When planning a PowerPivot for SharePoint deployment, you must plan for the following service accounts.

• Analysis Services service account. Analysis Services processes PowerPivot queries and data refresh jobs in the farm. This account is always specified during SQL Server Setup when you install PowerPivot for SharePoint.

• PowerPivot Service Application Pool. A PowerPivot service application is associated with a PowerPivot System Service that provides SharePoint integration and infrastructure for PowerPivot query processing in a farm. The application pool that you specify for a PowerPivot service application is the service identity of the PowerPivot System Service. You can have multiple PowerPivot service applications in a farm. Each one that you create should run in its own application pool.

Administrative permissions will fail to update if the person updating the credentials is not a local administrator on the computer. If this occurs, you can grant administrative permissions manually. The easiest way to do this is to run the PowerPivot Configuration timer job in Central Administration. With this approach, you can reset permissions for all PowerPivot servers in the farm. Note that this approach will only work if the SharePoint timer job is running as both farm administrator and as local administrator on the computer.

1. In Monitoring, click Review job definitions.

2. Select PowerPivot Configuration Timer Job.

3. Click Run Now.

As a last resort, you can ensure correct permissions by granting Analysis Services System Administration permissions to the PowerPivot service application, and then specifically add the service application identity to the SQLServerMSASUser$<servername>$PowerPivot Windows security group. You must repeat these steps for every Analysis Services instance that is integrated with the SharePoint farm.

You must be a local administrator to update Windows security groups.

1. In SQL Server Management Studio, connect to the Analysis Services instance as <server name>\POWERPIVOT.

2. Right-click the server name and select Properties.

3. Click Security.

4. Click Add.

5. Type the name of the account that is used for PowerPivot service application pool, and then click OK.

6. In Administrative Tools, click Computer Management.

7. Open Local Users and Groups.

8. Open Groups.

9. Double-click SQLServerMSASUser$<servername>$PowerPivot.

10. Click Add.

11. Type the name of the account that is used for PowerPivot service application pool, and then click OK.

If Central Administration service or the SharePoint Foundation Web Application service stops working due to an account reset or password expiration, you will encounter HTTP 503 "Service unavailable" error messages when attempting to open SharePoint Central Administration or a SharePoint site. Follow these steps to bring your server back online. Once Central Administration is available, you can proceed to update expired account information.

1. In Administrative tools, click Internet Information Services Manager.

2. For the identity of the site or Central Administration application pool is a domain user account that has an expired password, do the following:

   1. Right-click the application pool name and select Advanced Settings.

   2. Select Identity and click the … button to open the Application Pool Identity dialog box.

   3. Click Set.

   4. Type the username and password.

3. Run IISRESET. To do this, open an Administrator command prompt and type iisreset at the command.

4. In SharePoint Central Administration, in Security, select Configure managed accounts.

5. Click Edit to update the information of the managed account that has the expired password.

6. Select Change password now.

7. Click Use existing password.

8. Type the password, and then click OK.

If Reporting Services is installed, use the Reporting Services Configuration Manager to update passwords for the report server and the connection to the report server database. For more information, see Configuring Reporting Services for SharePoint 2010 Integration.

Tasks

Concepts