Error message when you try to add an existing Windows SharePoint Services 3.0 list to an Access 2007 database: "You do not have the necessary permissi

Symptoms:
You try to add an existing Microsoft Windows SharePoint Services 3.0 list to a Microsoft Office Access 2007 database. When the Windows SharePoint Services list contains a column name that has more than 64 characters, you receive an error message that resembles the following:

You do not have the necessary permissions to use the '' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.Note The term "column name" is what you see in the SharePoint user interface. Colum name is the column’s display name.

Cause:
This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters.

MS KB Article:

An error has occurred. Please contact your system administrator if this problem persists.

While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:

Error Message:

An error has occurred.

Please contact your system administrator if this problem persists. 

ULS Logs shows the following entry:

There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.

Checked the event viewer and found the following:

Event Viewer entries:

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category: Excel Services Web Front End

Event ID:  5234

Date: 12/7/2012

Time: 2:50:06 PM

User: N/A

Computer: XXX

Description:

No Excel Calculation Services is available in the farm.[User:

SHAREPOINT\system]

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category:  Excel Services Web Front End

Event ID: 5239

Date: 12/7/2012

Time: 2:50:06 PM

User:                     N/A

Computer: XXX

Description:

There was an error in communicating with Excel Calculation Services

http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx

exception: Unable to connect to the remote server

[Session: (null)

User: SHAREPOINT\system].

Troubleshooting Done:

1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d  which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.

2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.

3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.

4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.

5-Ran this below mentioned commands but no results:

stsadm -o setsharedwebserviceauthn -negotiate

stsadm -o execadmsvcjobs

6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d  but it is fine and no problems

7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html

Resolution that fix our issue:

If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:

<system.net>

<defaultProxy>

<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>

</defaultProxy>

</system.net>

------------------------------------------

what we have added in this: bypassonlocal = "true"

Issue has been resolved and excel services started working without any issues, Thank you

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, Thanks