There are cases where a password containing colon ( : ) characters will cause an MS SQL error (Login failed for user <username>) with an error state code of 8 (password mismatch) when trying to connect using the net.sourceforge.jtds.jdbc.Driver database driver.

To resolve this issue

  1. Change the password to not include colons.
  2. Change the password on the MS SQL server and ensure that you can successfully log in to that system (locally).
  3. Go to the UIM directory and change the uptime.conf file to reflect the new dbPassword value.
  • No labels