Error: Registering a database data store fails with 'Invalid database connection' or 'The data item is inaccessible'
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."
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