This article is designed to illustrate a common connection error scenario, as well as the solution for this specific error.
Description of error
The creation of a Data Location or the access to it is rejected with a "Failed to obtain JDBC Connection (...) Login failed for user xxx" error message.
In semarchy.xml, verify the password located in the corresponding Resource section.
In your database client, navigate to the user account that corresponds to the error displayed. Verify the hashed password matches the credentials in semarchy.xml. One approach is to type the password into a text file, then copy/paste into the user credentials section.
After updating the password, the user account is able to connect as expected.