sqlserver error from domain_logon/LogonUser: 1385

book

Article ID: 142365

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management CA Unified Infrastructure Management for z Systems CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

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. It may be that 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

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee957044(v=ws.10)?redirectedfrom=MSDN