Troubleshoot a database connection


Database connections are supported in Insights in ArcGIS Enterprise and Insights desktop.

When creating a new database connection or trying to access an existing database connection, ArcGIS Insights may not be able to establish a connection to the database.

When a connection problem occurs, one of the following messages appears:

  • Invalid credentials. Ensure the user name and password provided for this connection are correct indicates that an incorrect username or password was entered.
  • Invalid host. Ensure server name provided for this connection is valid and that the host is accessible indicates that an incorrect server name or port number was entered.
  • Invalid database name. Ensure database name provided for this connection is valid indicates that an incorrect database name or instance name was entered.
  • Insufficient privileges. Ensure the user has appropriate privileges on this database indicates that the database user requires additional privileges before a connection can be created between Insights and the database.
  • Something went wrong. Verify your connection properties, or click here to troubleshoot this is used for SAP HANA only. This error message indicates that one of the required parameters is incorrect.

  • Required library was not found. Ensure the database installation contains the required library. Click here for more information is used when an Oracle or PostgreSQL database is missing a required library. For Oracle, the required library is st_shapelib.dll on Windows or on Linux or Unix. For PostgreSQL, the required library is st_geometry.dll on Windows or on Linux.

The following list provides common causes of database connection problems that can be investigated:

  • The connection properties, such as User Name, Password, and Port Number are invalid. Verify that the connection properties for the database connection are correct. If changes are required for an existing database connection, you can edit these properties by updating the database connection.
  • You don't have the database privileges required to create the connection.
  • Database driver files are not present or are improperly configured on your organization's hosting server site (Insights in ArcGIS Enterprise only). To establish a connection, your portal's hosting server must have Java Database Connectivity (JDBC) files uploaded and registered. See Configure ArcGIS Enterprise to support Insights or Register Relational Data Store Type in the ArcGIS REST API help.
  • The database is not configured to accept connections. Some databases require additional configuration to allow remote clients to connect. For example, for Microsoft SQL Server databases, you must enable the server network protocol to accept connections over the network.
  • Connections have been blocked. Database administrators can prevent users from connecting to a database while they perform certain database maintenance tasks, such as backup and recovery, and upgrades.

If you're having trouble using a database connection that previously worked in Insights, you may need to update the connection. Deleting the database connection will render any dependent datasets inoperable. You should only delete a relational database connection when you are sure no datasets are dependent, or you purposefully want to disable upstream datasets.