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

book

Article ID: 34255

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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.

 

    Cause

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

    Environment

    UIM Server:  Any version
    MS SQL Server:  Any version

     

    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:
    • %
    • /
    • @