sqlserver error from domain_logon/LogonUser: 1385
search cancel

sqlserver error from domain_logon/LogonUser: 1385

book

Article ID: 142365

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe 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
...

Environment

Release : UIM 20.x

Component : UIM - SQLSERVER

Cause

- local logon rights/policy

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