search cancel

UIM - Login failed for user error for sqlserver probe

book

Article ID: 190092

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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


Environment

Release : 8.51 20.3

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
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 





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/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

Attachments