sqlserver error from domain_logon/LogonUser: 1385

book

Article ID: 142365

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

I am unable to monitor the SQL Server database from the hub installed at a client. I am able to RDP to the sql server from the hub and login with the service account I am using in the probe but I am unable to get the probe to connect to the database. I am getting domain login failed.

The sqlserver probe log shows an error when the connection is tested:
...
sqlserver: Error from domain_logon/LogonUser: 1385
sqlserver: Profile: test connection profile/test connection checkpoint - domain logon failed
sqlserver: Connection test to XXXXXXXXXX failed
...

Cause

- local logon rights/policy

Environment

Release : 8.51

Component : UIM - SQLSERVER

Resolution

Check to make sure that the user has 'Allow logon locally' permission on the sqlserver probe machine. Perhaps the domain admin account being used is also a member of another AD group/group policy that has a Deny Local logon policy.

A Windows administrator should be able to check this and/or take care of this change.


Additional Information

https://social.technet.microsoft.com/Forums/windowsserver/en-US/8d944475-f65f-4456-981a-cf370f351c56/create-a-gpo-for-allow-log-on-locally-permission?forum=winserver8gen