sqlserver probe error login failed 0x80004005 Cannot generate SSPI context

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Integrated security login to remove SQL Server via sqlserver probe is failing.

Profile: test connection profile/test connection
checkpoint/Connect - DB Provider: Code = 0x80004005
Source = Micosoft SQL Server Native Client 11.0
Description = Cannot generate SSPI context

Environment

Release: Any
Component: sqlserver probe

Resolution

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

For Windows authentication, perform the following:

- ensure that the user has access to the system hosting the monitored SQL Server.

- provide access rights to Niscache folder of the file system on which the CA UIM robot is installed.

- ensure that the user has local logon rights on the system where the sqlserver probe is installed.