Bug
The 'Create Address Locator' geoprocessing tool fails with the error message, "ERROR 000042: Failed to create the address locator. Underlying DBMS did not accept username/password" when the reference data is from a database connection for a database authenticated user, and the Windows machine uses a foreign Windows Region Formats.
| Bug ID Number | BUG-000127470 |
|---|---|
| Submitted | December 18, 2019 |
| Last Modified | December 20, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.7.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Workaround
- Do not log in to the database connection with database authentication credentials when running the 'Create Address Locator' tool within ArcMap. Use the operating system (OS) authentication when utilizing ArcMap.
- If using ArcGIS Pro, database authentication credentials work for SQL Server and PostgreSQL, but if Oracle is in use, utilize the OS authentication.
Steps to Reproduce
Bug ID: BUG-000127470
Software:
- ArcGIS for Desktop
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