Excel invalid file access method configured - Event 5557 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Excel invalid file access method configured

Event ID:   5557

Summary:    Excel Services Application supports two types of communication between its front-end Web application and back-end server components: Trusted Subsystem and Delegation. The communication type is controlled with the Access Model setting. An Excel Services Application administrator can also specify how the server component retrieves files: Use the process account the service runs as, or impersonate the user, requesting the workbook and delegate the user’s credentials. This error occurs when the Access Model is set to Trusted Subsystem and the file access method is set to Impersonation. In this configuration, the server component is unable to obtain or delegate the end user's credentials because they were not delegated from the front-end Web application.

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

  • Failure to load workbooks.

  • This event appears in the event log: Event ID: 5557 Description: Failed to load <workbook URL> with error: 'The server is configured to use Impersonation to access workbooks but impersonation cannot be used when the communication between the Excel Calculation Server and Excel Web Access is set to use a Trusted Subsystem.' [Session: <session ID> User: <username>]

Cause:   The AccessModel setting and the FileAccessMethod setting conflict.