UIM - Login failed for user error for sqlserver probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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. 

Environment

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

Resolution

Review the following possible causes of this issue: 

1. Please make sure native client 11 is installed on robot where sqlserver probe is deployed.
     https://www.microsoft.com/en-us/download/details.aspx?id=50402

Note: For SQL Server 2017, use Microsoft® SQL Server® 2012 / compatible Native Client as documented in our documentation below:

Microsoft® SQL Server® 2012 Native Client - Latest Servicing Release

 

sqlserver (SQL Server Monitoring) Release Notes (broadcom.com)

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

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes.html#concept.dita_b49428046e49ef6a121825f32deba3fc96c0ff27_AccessPrerequisites