Publishing Access Services Database to SharePoint 2010 gives ‘<URL> did not respond…’

While building a portion of our demo SharePoint 2010 farm, I encountered an error when publishing an Access 2010 database to a SharePoint 2010 Access Services site.

The error which was shown was ‘<URL> did not respond. Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older version of Microsoft Access Services which is not compatible with Access 2010’:

Access Services Publish Error

After checking that the Access Services farm and web application features were enabled, and that the enterprise features were enabled on the site collection to which I was attempting to publish the Access database (all were fine), I looked in the server application logs on the WFE servers in the demo farm, and on one of the farm servers saw the error ‘There is no default Access Services Application Proxy’:

Event Viewer Error

Checking the Service Application Associations (Central Administration –> Application Management –> Configure service application associations) showed that the Access Database Service proxy was not associated with the default proxy group:

Proxy Associations

After adding the Access Database Service proxy to the default group, publishing the Access database to SharePoint proceeded without a hitch.

In our case, the proxy not being associated with the default proxy group was due to us using PowerShell to configure the Access Service Application. If you do the same, check whether the proxy has been associated with the default group (or whatever proxy group you want it associated with).

4 Replies to “Publishing Access Services Database to SharePoint 2010 gives ‘<URL> did not respond…’”

  1. I got the same error. Understand what you’ve explained up to the bit where you said “After adding the Access Database Service proxy to the default group…” How do you add this? Sorry i’m still new to SharePoint 2010.

  2. Tex: I am facing the same issue…can you tell me how to add Access Database Service proxy to defalt group…I could not find it.

  3. To modify the membership of a proxy group, start Central Admin, then click 'Application Management', then 'Configure service application associations'. Select the proxy group that you wish to change the membership of (the dfault group is named 'default', this is the one that most administrators will need to change), and then tick the checkbox against the proxy you wish to add to the group you've selected.

Leave a Reply

Your email address will not be published.