Configure SQL Server as an External Security Datastore for ArcGIS Server Java

Summary

Instructions provided describe how to configure ArcGIS Server Java on Windows to utilize SQL Server (Express) as an External Security Datastore.

Procedure

1. Install Java Runtime Environment (http://www.java.com/en/download/index.jsp).
2. Install ArcGIS Server Java 9.3, 9.3 Service Pack 1, or 9.3.1.
3. Install .NET Framework 2.0
4. Step 4 - Install SQL Server Express 2005 (English Version)
   * Enable Mixed Mode Authentication during install.
   * Make sure to install SQL Server Management Studio Express.
5. Configure SQL Server Express as follows:
   A. Open SQL Server Management Studio Express > Create Database Named: "ArcGISPrincipalStore".
   B. In SQL Server Configuration Manager > Network Configuration > Protocols for sqlexpress > TCP/IP > ENABLED.
   C. In SQL Server Configuration Manager > Network Configuration > Protocols for sqlexpress > TCP/IP > Properties > IP Addresses:
   a. Delete all entries for "TCP Dynamic Ports".
   b. IPAll > TCP Port > 1433.
   c. Restart SQL Server.
6. Install the JDBC Driver for SQL Server 2005 using the following procedure:
   
   A. Download and unzip the JDBC Driver from: http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en to: C:\Program Files\Microsoft sql Server JDBC Driver 2.0.
   B. Run the following command:
   Start > Run > set CLASSPATH=.; C:\Program Files\Microsoft sql Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar; C:\Program Files\Microsoft sql Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc4.jar;.
   C. Copy C:\Program Files\Microsoft sql Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar & sqljdbc4.jar to: C:\Program Files\ArcGIS\java\manager\config\security\lib.
7. Setup the External Database Security Store (SQL Server) in ArcGIS Server Manager:
   A. Open ArcGIS Server Manager > Security > Settings > Security Store > Configure�
   a. Choose External Database > Configure�
   b. JDBC Driver: com.microsoft.sqlserver.jdbc.sqlServerDriver.
   c. JDBC URL: jdbc:sqlserver://localhost:1433; databaseName=ArcGISPrincipalStore.
   d. Username: sa.
   e. Password: <SAPASSWORD>.
   f. Test Connection / OK > Next > Finish.
   g. Restart the ArcGIS Server Object Manager Service.
   h. Log out and log in to ArcGIS Server Manager.