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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

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.

 

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:

• %
• /
• @