sqlserver probe unable to connect to database with error 1385

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Failed to connect to MSSQL server using Windows Authentication to the sqlserver probe during test connection in probe configuration with the following in the sqlserver_monitor.log:

sqlserver: Error from domain_logon/LogonUser: 1385 

sqlserver: Profile: test connection profile/test connection checkpoint - domain logon failed 

sqlserver: Connection test to machine failed 

Environment

Release: CNMSPP99000-8.4-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component:

Cause

The user that is being used to connect to the MSSQL server from the probe machine does not have logon locally rights on the probe machine.

Resolution

Make sure that the user has logon locally permissions on the sqlserver probe machine.