Sql query operation fails with User impersonation failed / Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

  • Document ID:KM03118036
  • Creation Date:14-Mar-2018
  • Modified Date:19-May-2021
    • Micro Focus Products:
      operations orchestration

Summary

Sql query operation fails if 'Deny Log on Locally' has been applied to a group the user part of.

Error

Sql query operation fails with User impersonation failed / Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
 

Cause

This error is thrown because the user specified in the operation inputs is not allowed to Log on Locally on the remote server. This typically happens if the Deny Log on Locally has been applied to a group the user part of.

 

Fix

In order to fix this, the user should have the necessary settings so he can Logon locally on the remote machine.