ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 143711

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Unified Infrastructure Management (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:

Jan 10 09:35:23:927 [5784] 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  

Jan 10 09:35:23:927 [5784] 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()).  

Jan 10 09:35:23:927 [5784] sqlserver: Connection test to x.x.x.x,1433 failed 

Jan 10 09:35:23:927 [5784] sqlserver: SREPLY: status = 0(OK) ->x.x.x.x/52905 

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

Jan 10 09:35:23:927 [5784] sqlserver: ciGetDeviceIdentifiers - xyz.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.

Attachments