Bug
When configuring security in the "Settings" panel of the "Security" tab, using any account having "&" characters in the password will fail when trying to connect to a SQLServer user or role store w/o "Use Trusted Connection".
| Bug ID Number | NIM035659 |
|---|---|
| Submitted | May 27, 2008 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Version Fixed | N/A |
| Status | Fixed |
Description
Note:
This bug has been fixed at ArcGIS 9.3 Service Pack 1.
ArcGIS Server Manager 9.3 has a wizard to configure security. The Manager user may use Microsoft SQL Server as the location for users and roles.
In the wizard panel for specifying the SQL Server, the user enters the server name, and then connects to the server. If the option to 'Use trusted connection' is unchecked, then the connection uses a SQL login that is defined in the database. If this option is used and the password contains an ampersand (&) character, then the wizard will fail when attempting to finish the configuration.
The error message may contain a statement such as:
- "Unterminated string passed in"
-or-
- "Length cannot be less than zero."
Cause
A bug in the Manager wizard causes an error when the SQL login password contains an ampersand (&) character.Workaround
- As a workaround, change the password so that it does not contain any ampersand (&) characters.
Steps to Reproduce
Bug ID: NIM035659
Software:
- No Product Found
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