Configuring an external database as the security store

To configure an external database as the ArcGIS security store, you will need to first prepare your database, then configure it using ArcGIS Server Manager.

Preparing the Database

1. Install the relational database server following the instructions provided by the database vendor.
2. As an administrative user, create an empty database.
3. Create a user account with read/write privileges to this database.
4. Determine the location of the JDBC drivers. Identify the driver that implements JDBC access and note its fully qualified class name. For example, the class name of the JDBC driver for Apache Derby is org.apache.derby.jdbc.ClientDriver.
5. ArcGIS Server will communicate with the database server through the JDBC driver provided. Since this communication is usually over TCP, you may need to configure the database server to accept TCP connections. Refer your database documentation for more information regarding this.
6. Build the JDBC URL required to connect to your database server. Refer to your database documentation for the exact format of the URL. The generic format of the JDBC URL is *jdbc:<database_server>://<machine_name>:<port>;databaseName=ABC*.

Configuring the security store in Manager

1. Copy the JDBC driver .jar file to the <ArcGIS Server Installation Directory>\java\manager\config\security\lib\ folder.
2. Log in to ArcGIS Server Manager. On the Security panel, click Settings and select the Security Store tab.
3. Click Configure, select External Database, then click Configure. The dialog box shown below appears.

   The table below describes the fields in this dialog box:

   Field	Required/Optional	Description
   JDBC Driver	Required	The fully-qualified class name that implements the JDBC driver for the particular Database Server.
   JDBC URL	Required	The JDBC URL to connect to the Database Server.
   User name	Required	The user name of an account with write access to a database instance on the Database Server.
   Password	Required	The user's password.
   Test Connection	N/A	Tests the connection to the database server. If the test succeeds, you can save the configuration. Otherwise, the parameters need to be changed.

4. In the JDBC Driver input box, enter the name of the driver, determined at step 4 in the Preparing the Database section.
5. In the JDBC URL input box, enter the URL that you built at step 6 in the Preparing the Database section.
6. Enter the user name and password of the account you created at step 3 in the Preparing the Database section.
7. Click Test Connection to verify that ArcGIS Manager is able to connect to the database server.
8. Click Next to accept the external database as the role store.
9. Click Save on the Summary page to apply the configuration.