Login fails for SQL database user when password contains an exclamation point

Document ID : KB000034255
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

There is a known issue where the data_engine will not be able to establish a connection to a MS SQL Database despite the fact that the same username can successfully log in through SQL Management Studio, or a System DSN test, which is caused by an exclamation point (!) in the password of the SQL user that is configured in data_engine.

Environment:  

UIM Server:  Any version
MS SQL Server:  Any version

Cause: 

Some special characters in the UIM database password are not handled correctly preventing a connection to a MS SQL Server database.

Resolution:

The resolution is to change the password to one that does not contain an exclamation point.  Most other special characters should be fine.

Additional Information:

Other special characters to avoid in UIM database passwords:

  • %
  • /
  • @