sqlserver probe unable to connect to database with error 1385

Document ID : KB000006479
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Resolution:

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