Office 365 connection to Access 2013 web app data failed

Symptoms

Assume that you have connected an application such as Microsoft Excel or a Microsoft Access desktop database to data that is located in an Access app on Microsoft Office 365 SharePoint Online. When you open the application and try to view the data in the connected Access app, you receive the following error message:

Connection failed:

SQLState: '08001'

SQL Server Error: 53

[Microsoft)[SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

Cause

The data in the Access app is stored in databases on SQL Azure. During a disaster recovery process, the database for the Access app was is moved to a new SQL Azure server. Therefore, The the name of the server in your current connection information is no longer valid.

Note We enacted a disaster recovery system to protect your databases on SQL Server. Disaster recovery is a promise that we make to you that your data is stored in two Microsoft data centers in different regions to allow us to be resilient to disasters.

Resolution

To resolve this issue, the administrator or owner of the Access app must re-create the connection information in the Access app client. In the application that links to the Access app data, the administrator or app owner must either create a new connection or revise the external data connection to reflect the new server name and the new password. To do this, follow these steps:
  1. In Access 2013, open the Access app that contains the data to which you want to connect.
  2. Click File, click Info, and then click the Manage button in the Connections section.
  3. Click Disable All Connections.
  4. Click Yes when you receive the message "Disabling all connectivity will prevent external programs or reports from accessing the app and may cause other applications to break. Are you sure you want to disable all connectivity?"
  5. Click the Manage button again.
  6. Select From Any Location.
  7. Select Enable Read-Write Connection or Enable Read-Only Connection.
  8. Click View Read-Write Connection Information or View Read-Only Connection Information to view the new connection information.

    A screen shot for view connection information
  9. Reconnect to the data in the Access app using the new connection information.

More Information

All connections to the Access app data on SQL Azure have to be recreated or revised to reflect the new server name and password.

For information about how to connect through the ODBC administrator see Administer ODBC data sources.

If you are connecting from a Microsoft Access desktop database, you can use code to create a connection that does not use a data source name (DSN). For more information about how to create a DSN-less connection, see How to create a DSN-less Connection to SQL Server for linked tables in Access.

Note In the code in the DSN-less connection article, you must change the DRIVER from "SQL Server" to "SQL Server Native Client 11.0" as follows:

stConnect = "ODBC;DRIVER=SQL Server Native Client 11.0;SERVER=" & stServer & ";DATABASE=" & stDatabase & ";UID=" & stUsername & ";PWD=" & stPassword

You may have to contact the person who created the connection in order to re-create the connection to the Access app data.
Properties

Article ID: 2922359 - Last Review: 31 Mar 2014 - Revision: 1

Feedback