Access Data Services no longer available - Event 28 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010

Alert Name:   Access Services is no longer available

Event ID:   28

Summary:   The front end Access application sent a request to a specific Access Services server computer and encountered an unexpected exception. This can indicate an intermittent problem or a problem with the server computer. In these cases, the front end Access application attempts to load-balance to a different server computer. 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 applications fail to refresh data.

  • Access Services applications fail to load or be displayed correctly.

  • This event appears in the event log: Event ID: 28 Description: The Access Data Services is no longer available. [Session: <session ID> User: <username>].

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

  • The front end Access application encountered an intermittent failure when it sent a request to the Access Services server computer.

  • The specific Access Services server computer is in an invalid state and must be restarted.

  • There are network related failures that are preventing the server that is running the front-end Access application from contacting the Access Services server computer.

Resolution:   Restart the server

  1. Before restarting the Access Services server computer, refer to the System Center Operations Manager reports to learn how often this problem occurs. If the problem occurs intermittently and Access Services automatically recovers from it, do not restart the server computer unless the symptoms noted above persist.

  2. Restart the Access Services server computer.

  3. If the problem occurs often, and restarting the server computer does not correct the issue, verify that the server computer is functioning correctly. You may need to reinstall Microsoft SharePoint Server on the server computer and join it to the SharePoint farm.