sqlserver probe connection error not associated with a trusted SQL Server connection

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are getting the alarm message shown below. Why are these types of alarms  triggering and what action needs to be taken from the DB end or UIM end to fix this issue?

(Profile: Server/check_dbalive/Connect - DB Provider: Code=0x80040e4d Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.). 

Environment

• Release: 20.4
• Component: sqlserver

Resolution

• This is quite a common error and can happen when an incorrect username is communicated to MS SQL Server.
• The fix is to provide the correct username.
• This can also happen if you are attempting to login to MS SQL Server with a MSSQL Server user but the MSSQL server is only configured to connect via Windows Login.