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

Document ID : KB000034255
Last Modified Date : 04/02/2019
Show Technical Document Details
Issue:
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:
    • %
    • /
    • @