Excel Services Application configuration database access failed - Event 5244 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Excel Services Application configuration database access failed

Event ID:   5244

Summary:   The application server for Excel Services Application failed to access the configuration database and might not be able to read or save any settings. All settings for Excel Services Application are stored in the configuration database.

Symptoms:   One or more of the following symptoms might appear:

  • Excel Services Application might fail to provision.

  • Excel Services Application might not start.

  • Excel Services Application might be interrupted and user workbooks might fail to load.

  • This event appears in the event log: Event ID: 5244 Description: Unexpected error when trying to access service settings in the SharePoint configuration database. Make sure the proxy for this service application is a member of the default proxy group for the active web application. Error =<error returned from SharePoint>.

Cause:   One or more of the following might be the cause:

  1. Configuration database might be offline or unavailable.

  2. Permissions on the configuration database have changed, or permissions for the application pool account in which Excel Services Application runs have changed, and Excel Services Application no longer has access to the configuration database.

Note

You must be a member of the Farm Administrators SharePoint group to perform the following task.

Resolution:   Grant correct permissions to the database access account

  • To find the database access account:

    1. On the Central Administration page, on the Quick Launch, click Security, and in the General Security section click Configure service accounts.

    2. On the Service Accounts page, in the Credential Management section, from the drop-down list select the Service Application Pool option for the application pool that runs Excel Services Application. When this option is selected, the name of the Excel Services Application appears in the list box below the drop-down list; for example, Excel Service Application.

    3. Note the account that is selected in the Select an account for this component list, and click OK.

  • To verify that the account has correct permissions in SQL Server:

    1. Connect to the computer that runs SQL Server by using an account that has Administrator permissions.

    2. In SQL Server Management Studio, in the Object Explorer navigation pane, expand the Security node, and then click the Logins node. The name of the database access account indicates that it is a SQL logon account ; for example, ##MS_PolicyTsqlExecutionLogin##.

    3. If the account exists, in the Object Explorer navigation pane, expand the Databases node, expand the configuration database node (for example, WSS_Config), expand the Security node, and then click Roles.

    4. Expand the Database Roles node, right-click db_owner, and then select Properties.

    5. In the Database Roles Properties dialog box, check whether the database access account is in the Members of this role list. If the account is not listed, click Add.

  • To verify that Excel Services Application can read from the configuration database

    1. On the computer, click Start, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint Management Shell.

    2. At the command prompt, type the Windows PowerShell cmdlet name Get-SPExcelServiceApplication to obtain the settings of the specified Excel Services Application. These settings are read from the configuration database.