ERROR
Registering a database data store fails with 'Invalid database connection' or 'The data item is inaccessible'
Error Message
When registering a database data store in ArcGIS Server Manager, the following error occurs:
"Invalid database connection"
Attempting to register the same database data store in ArcGIS Desktop returns the error:
"The data item is inaccessible"
Viewing the ArcGIS Server logs shows this error message:
"The connection property set was missing a required property or the property value was unrecognized. Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly."
Cause
The machine where ArcGIS Server is installed is missing the 64-bit client libraries for the specific DBMS to which the connection is being made.
Solution or Workaround
Install the 64-bit client libraries for the database on each ArcGIS Server machine in the site. It is important to remember that ArcGIS Server is a 64-bit application and requires a 64-bit database client, versus ArcGIS Desktop which is a 32-bit application and requires a 32-bit database client. After installing the database client, open the Administrative Tools > Services dialog and restart the ArcGIS Server service so that the new database libraries and variable changes can be detected.Setting up a connection to SQL Server
Setting up a connection to Oracle
Setting up a connection to PostgreSQL
Article ID: 000011608
- ArcGIS Server
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App