sqlserver connection using Windows Auth. error

Article Id: 143711

Status: Published

Updated On: 22-07-2020 08:53

Products:

DX Infrastructure Management , NIMSOFT PROBES , DX Infrastructure Management

Issue/Introduction:

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

sqlserver probe version 5.42

robot version 7.97HF3

Os Windows Server 2012 R2

remote connection in sqlserver probe (polling robot info same as above)

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 10.230.19.117,1433 failed

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

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

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

Environment:

Release : 9.0.2

Component : UIM - SQLSERVER

Resolution:

Customer was able to use SQL authentication instead of Windows authentication. Customer suspected that a given cipher may have been disabled when using Windows auth.