UIM - Login failed for user error for sqlserver probe

Products

• NIMSOFT PROBES
• DX Infrastructure Management

Issue/Introduction

Getting below error while testing conenction to different databases remotely from sqlserver probe
It failed for 2008, 2014 ,2016 version target mssql databases 

Environment

Release : 8.51

Component : UIM - SQLSERVER
sqlserver 5.42 HF3

Resolution

Can refer below steps to check connectivity and access prerequisites for sqlserver probe 

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

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





https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-start-the-utility?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

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

Windows authentication have specific access permissions 

KB:sqlserver error from domain_logon/LogonUser: 1385

https://knowledge.broadcom.com/external/article?articleId=142365

KB:sqlserver probe unable to connect to database with error 1385

https://knowledge.broadcom.com/external/article?articleId=6479

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

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes.html#concept.dita_b49428046e49ef6a121825f32deba3fc96c0ff27_AccessPrerequisites