Access Services server is not available - Event 29 (SharePoint Server 2010)


Applies to: SharePoint Server 2010

Alert Name:   Access Services server computer is not available

Event ID:   29

Summary:   A front-end Access application computer cannot locate or send requests to any server computer that is running Access Services. The Access Services server computer is required to query data that is typically used in Access Services reports.

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

  • Access Services does not render any data in forms, reports, or any other view of an Access application in the browser.

  • This event appears in the event log: Event ID: 29 Description: No Access Data Services is available in the farm.[User: <username>].

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

  • The Access Services server computer is not running.

  • Access Services was not started on the server computer.

  • The proxy that the front-end Access application is not the default member of the default proxy group for Access Services.

Resolution:   Verify that Access Services runs on the server

  1. On the Central Administration Home page, in the System Settings section, click Manage servers in this farm.

  2. Select the server computer that hosts the Access Database Service.

  3. On the Services on Server page, check whether Started is indicated for Access Services in the Status column. If it is not, click Start in the Action column.

Resolution:   Verify that the proxy for the service application is the default member for Access Services

  1. On the SharePoint Central Administration Home page, on the Quick Launch, click Application Management. In the Service Applications section, click Configure service application associations.

  2. On the Service Application Associations page, in the Application Proxy Group column, click the name of the proxy group for your front-end Access application. The default name for the proxy group is default.

  3. In the Configure Service Application Associations dialog box, make sure that the check box for the Access Services proxy is selected. If there is more than one Access Services application proxy and the word [default] does not appear after the name of the proxy you want to use, select the check box, and then click [set as default].

  4. Click OK.