UIM - Login failed for user error for sqlserver probe
search cancel

UIM - Login failed for user error for sqlserver probe


Article ID: 190092


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


We are getting the below error while testing the connection to different databases remotely, from the sqlserver probe:

COM Error: Code=0x80040e4d Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft]SQL Server Native Client 11.0][SQL Server]Login failed for use

It failed Similarly for MS SQL versions: 2008, 2014, 2016, 2017. 


Release : UIM 20.x
Component : UIM - SQLSERVER
sqlserver 5.42 HF3


Review the following possible causes of this issue: 

1. Please make sure native client 11 is installed on robot where sqlserver probe is deployed.
Note: For SQL Server 2017, use Microsoft® SQL Server® 2012 / compatible Native Client as documented in our documentation below:

2) Can use below reference methods to test connectivity outside of sqlserver probe 

sqlcmd utility - Start the sqlcmd utility - SQL Server | Microsoft Learn
A network-related or instance-specific error occurred - SQL Server | Microsoft Learn

3. Verify what type of Authentication you are using with those credentials to access the target databases.
Is this Windows authentication or SQL server authentication then use the appropriate authentication in probe connection

Windows authentication has specific access permissions 

sqlserver error from domain_logon/LogonUser: 1385 (broadcom.com)

4. Ensure the access prerequisites are met depending on the type of authentication used for profile connection