We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Backup

How to Resolve "Error with SQL authentication" Warning

  • Last updated on

Typically, this warning occurs when a user chooses to enter credentials for the Microsoft SQL Server connection and those credentials are for a Windows account, and not a Microsoft SQL Server account. When the Agent is configured to perform a VDI backup of the Microsoft SQL Server databases, the entered credentials must be those of a SQL account, not a Windows account. To verify this error, open the Application Event Logs on the Microsoft SQL Server, and look for Event ID 18456 at the time of the backup. This event indicates there was a failed login using a Windows account. 

By default, the Barracuda Backup Agent uses the Local System (NT Authority\System) account to connect to Microsoft SQL Server. If you enter Microsoft SQL Server credentials when setting up the data source, the Agent attempts to use those first:
error_with_sql_auth_01.png

If the credentials entered during setup fail, the Barracuda Agent defaults to the Local System account credentials to allow for successful database backup, and displays the warning message “Error with SQL authentication”:
error_with_sql_auth.png

To clear this warning, remove the credentials entered during data source setup:

  1. Log in to Barracuda Backup, and go to the Backup > Sources page.
  2. Click Edit to the right of the Microsoft SQL Server data source to edit the share settings, and scroll down to the authentication section:
    error_with_sql_auth_02.png 
  3. Clear the Microsoft SQL Server Requires Authentication option:
    error_with_sql_auth_03.png 
  4. Click Save to save your settings.

The Barracuda Agent uses the Local System account credentials for all future database backups.

Last updated on