Tag Archives: error

SharePoint 2010 Excel Services Error: Unable to process the request

imageEvery once in a while when I’m using the TFS SharePoint portal which relies on Excel Services to render the graphs for work items and tasks, I sometimes receive the error message “Unable to process the request.

Looking on the server’s event logs, we see a message that relates to Excel Services:

There was an error in communicating with Excel Calculation Services :32843/1d6c7449da5d4abd9e3e12d23d550738/ExcelService*.asmx">http://<SharePoint>:32843/1d6c7449da5d4abd9e3e12d23d550738/ExcelService*.asmx exception: An error has occurred.

The quick fix for this is to restart IIS by opening a CMD prompt as Administrator mode then run the IISRESET commands.

If this doesn’t work, or it appears as though it is referencing one of your SharePoint servers that does not participate in this service, the next step is to open Central Admin, go to the page for managing services on the servers, and stop and start the Excel Services on each server to “reregister” the correct topology for your farm configuration.

SharePoint 2010 has SQL error connecting to local database

Log entry for EventID 5586: Unknown SQL Exception 297 occurred.

Additional error information from SQL Server is included below.  

The user does not have permission to perform this action.

This is occurring because your SQL Server has not been configured to use named pipes

Fix: Open the SQL Server Configuration Manager and browse down to SQL Server Network Configuration – Protocols and Right-click “Named Pipes” in the right pane and choose Enable.

You may need to restart the server for changes to take effect.