Configure a database connection for ArcGIS Server

To connect an ArcGIS Server site to a supported database platform, you need to do the following:

1. Install and configure the database client software.
2. Restart ArcGIS Server.
3. Test your connection.

Install and configure the database client software

The following topics provide instructions on how to install and configure client software for specific databases. Keep in mind that you must install a release of the client software that is compatible with the release of the database to which you want to connect.

Follow the instructions in these topics to set up database client software on the ArcGIS Server machine:

• Connect to Dameng from ArcGIS
• Connect to Db2 from ArcGIS
• Connect to Informix from ArcGIS
• Connect to Oracle from ArcGIS
• Connect to SAP HANA from ArcGIS
• Connect to SQL Server from ArcGIS
• Connect to Teradata from ArcGIS

No separate database client is needed to connect to PostgreSQL.

Restart ArcGIS Server

If ArcGIS Server was running before you configured an Oracle database client on each ArcGIS Server machine, you must restart ArcGIS Server. You can restart ArcGIS Server from the Windows Services interface on each machine in your site.

Test your connection

You should test the connection by doing the following*:

1. Register the database with the ArcGIS Server site.
2. Publish a service using data residing in the database.

* For Informix and Db2 z/OS databases, use ArcMap 10.8.x to create a service definition file that does not contain the service data, and publish the service definition file to test the connection.

If you encounter problems with your connection, consult the server logs for more information. To learn more about server logging, see Work with server logs.