sqlserver probe unable to connect to database with error 1385

book

Article ID: 6479

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

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 

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.

Environment

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

Resolution

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