sqlserver error from domain_logon/LogonUser: 1385

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

DX UIM 20..4.x / 23.4.x

SQL Server probe any version

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://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee957044(v=ws.10)?redirectedfrom=MSDN

https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-r2-and-2012/dn221980(v=ws.11)