UIM sqlserver probe connection using Windows Authentication returns "SSL Security error"

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Trying to set up a connection in sqlserver probe to DB using Windows Authentication and getting error connecting.

Error snippet from log:

sqlserver: Profile: test connection profile/test connection checkpoint/Connect - DB Provider: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error  

sqlserver: Profile: test connection profile/test connection checkpoint/Connect - DB Provider: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()).  

sqlserver: Connection test to ###.###.##.###,1433 failed 

sqlserver: SREPLY: status = 0(OK) ->###.###.##.###/52905 

Jan 10 09:35:23:927 [5784] sqlserver: Profile timeout checked 

Jan 10 09:35:23:927 [5784] sqlserver: ciGetDeviceIdentifiers - example.net found (remote device) 

Environment

• Release : 9.0.2, 20.3.x
• Component : UIM - SQLSERVER

Resolution

Please do the following if you want to use the SQL server authentication username:
1- double-click on the sqlserver probe.
2- Select the Connections tab
3- Right-click and edit the profile
4- Change the Authentication to SQL Server authentication
5- Enter the user ID and password.
6- Test the connection and screenshot the result.
7- Verify if the issue has been resolved.