Troubleshoot connections

You may encounter problems when connecting to a database or enterprise geodatabase from an ArcGIS Desktop client or when trying to register a database with an ArcGIS Server site. The following sections provide information on some common causes of connection problems.

DBMS client files are not present or are improperly configured

When you connect from a client application to a database or enterprise geodatabase, the database management system client files must be present on the connecting client computer. Each DBMS has different requirements when it comes to setting up and configuring its client applications. See your DBMS documentation to be sure you have properly installed and configured your DBMS client on the ArcGIS client computer.

Note that when you upgrade your database, you should update the DBMS client installations as well.

ArcGIS Desktop clients and ArcGIS Server include PostgreSQL client files; therefore, you do not need to separately install and configure a DBMS client to connect to PostgreSQL.

The database is not configured to accept connections

Databases may require additional configuration to allow remote clients to connect. For example, to connect to a PostgreSQL database, the database administrator must alter the pg_hba.conf file to allow clients to make a connection.

SQL Server databases need network protocols set to accept connections over the network.

In many cases, the message you see in ArcGIS indicates you provided a bad login when connecting. If you are sure the user name and password you provided are correct, confirm the database can accept connections from remote clients.

See your database management system documentation to learn how to configure the database to accept client connections.

Connections have been blocked

There are several ways an administrator could prevent users from connecting to a database. This is typically done to perform certain administration tasks, such as backups or upgrades, without any users connected to the database.

The database administrator can block connections through functionality provided in the database management system. Most database management systems can be placed in a quiescent mode, which prevents new connections from being made to the database.

For enterprise geodatabases, the geodatabase administrator can block new geodatabase connections from within ArcGIS Desktop or using the AcceptConnections ArcPy function. When a user tries to connect to the geodatabase when it is in this state, the following message is returned:

Failed to connect to database. 
The geodatabase is not accepting connections. 
Please contact your geodatabase administrator.

If you receive this message when attempting to connect to an enterprise geodatabase, contact your geodatabase administrator to determine if the block was intentional and, if so, when you can expect the geodatabase to be available again.