Guest Processing for Microsoft SQL Server Results in Logon Failure Error

Challenge

The following tasks fail with the error shown below:

• Back up of SQL Server transaction logs.
• Truncation of SQL Server transaction logs.
• Collection of SQL instances metadata for Veeam Explorer for Microsoft SQL.

While the error message varies depending on the actual operation, there is a common error thrown in the job sessions:

"Logon failure: the user has not been granted the requested logon type at this computer. Code: 1385"

Cause

This issue occurs due to missing required permissions.

Solution

The permissions of the account specified for use with Application-Aware Processing need to be adjusted on the SQL server.

More information can be found in:

• Veeam Backup & Replication Permission Requirements
• Veeam Explorer for Microsoft SQL Permission Requirements

To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.