Bug
Unable to add users or roles to the default security store for ArcGIS Server for Java if using a non-English version of Windows.
| Bug ID Number | NIM043593 |
|---|---|
| Submitted | March 25, 2009 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Server (Java) |
| Version found | 9.3.1 |
| Operating System | Windows OS |
| Operating System Version | 2003 |
| Version Fixed | N/A |
| Status | Fixed |
Workaround
Implement SQL Server Express as an External Data Store:Step 1 - Install Java Runtime Environment (http://www.java.com/en/download/index.jsp)Step 2 - Install ArcGIS Server JavaStep 3 - Install .NET Framework 2.0Step 4 - Install sql Server express 2005 (English Version)* Enable Mixed Mode Authentication during Install* Make Sure to Install sql Server Management Studio expressStep 5 - Configure sql Server express as follows:A. sql Server Management Studio express > Create Database Named: "ArcGISPrincipalStore"B. sql Server Configuration Manager > Network Configuration > Protocols for sqlexpress > TCP/IP > ENABLEDC. sql Server Configuration Manager > Network Configuration > Protocols for sqlexpress > TCP/IP > Properties > IP Addressesa. Delete all entries for "TCP Dynamic Ports"b. IPAll > TCP Port > 1433D. Restart sql ServerStep 6 - Install the JDBC Driver for sql Server 2005 -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.0B. Run the following command:a. 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\libStep 7 - Setup the External Database Security Store (sql Server) in ArcGIS Server Manager:A. Open ArcGIS Server Manager > Security > Settings > Security Store > Configure…a. Chose External Database > Configure…b. JDBC Driver: com.microsoft.sqlserver.jdbc.sqlServerDriverc. JDBC URL: jdbc:sqlserver://localhost:1433; databaseName=ArcGISPrincipalStored. Username: sae. Password: <SAPASSWORD>f. Test Connection / OK > Next > Finish g. Restart the ArcGIS Server Object Manager Serviceh. Logout and Login to ArcGIS Server ManagerSteps to Reproduce
Bug ID: NIM043593
Software:
- ArcGIS Server (Java)
Get notified when the status of a bug changes
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