sqlserver probe creating domain logon failed, probe has to be started for connection test and cannot generate SSPI context errors

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Bulk alerts got created for databases even though account has got all the required permissions.

Can see below errors in logs

Jul 26 09:50:21:042 [5924] sqlserver: Profile: test connection profile/test connection checkpoint, domain logon using user ###\###...
Jul 26 09:50:21:042 [5924] sqlserver: start Converting encrypted String to AES 256 : encrypted Str:  
Jul 26 09:50:21:042 [5924] sqlserver: (nimDecrypt) decoding of encrypted string failed.
Jul 26 09:50:21:042 [5924] sqlserver: end Converting encrypted String to AES 256 : AES 256 encrypted Str: (null) 
Jul 26 09:50:21:042 [5924] sqlserver: Failed to convert encrypted string() to AES256 - result((null))
Jul 26 09:50:21:248 [5924] sqlserver: Error from domain_logon/LogonUser: 1326
Jul 26 09:50:21:248 [5924] sqlserver: Profile: test connection profile/test connection checkpoint - domain logon failed
Jul 26 09:50:21:248 [5924] sqlserver: Connect/Retrun False
Jul 26 09:50:21:248 [5924] sqlserver: Connection test to localhost failed

Environment

Any supported UIM version

sqlserver probe : 5.61 

Resolution

Deploy sqlserver build build 5.61T1 attached to this KB following below steps:

To deploy it, first delete the util folder under ~\AppData\Local\Temp\

• make sure you take backup of your sqlserver probe folder,
• delete the probe from IM as well as folder under nimsoft folder
• then deploy this as fresh probe

Deploy the sqlserver-5.61-T1 and create a connection
Create new connection/profiles and monitor it