sqlserver connection using Windows Auth. error

book

Article ID: 143711

calendar_today

Updated On:

Products

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.