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).

Microsoft SharePoint Conference 2009: Day 4

Today’s highlights from the sessions I attended:

  • One of the new features of SharePoint 2010 is Access Services – we at Black Marble have been doing some work using Access Services (see Richard’s blog post for more details, along with the Access 2010 demo on Channel9), which Robert and I presented during the first session of the day.  The talk was received well, with a number of people wandering over to me during the rest of the day to let me know they liked it.
  • The number of management packs for System Center Operations Manager required to monitor SharePoint 2010 has been reduced to precisely one!