SQL Event 18456 during file backup of SQL server

Problem

If the file system of a SQL server is backed up but the Backup Exec SQL agent is not licensed/used and the account used for the file backup has no access to SQL, events 18456 may be present from SQL server.   

Error Message

Log Name:      Application

Source:        MSSQLSERVER
Date:          3/13/2013 5:00:14 AM
Event ID:      18456
Task Category: Logon
Level:         Information
Keywords:      Classic,Audit Failure
User:          DOM\BEACCT
Computer:      SERVERNAME.DOM.COM
Description:
Login failed for user DM\BEACCT. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ###.###.###.###]

Cause

When the file backup of a SQL server is initiated, the SQL agent, even if not licensed or used, will query SQL server to determine what databases are active so that their database files can be excluded from the file backup.  If the account used for backup has no access to SQL server, this file exclusion information cannot be obtained and SQL server may create events when the access attempt is made.

Solution

The account used by Backup Exec for SQL server file backups should have access to all SQL instances present so that the automatic exclusions can be created.


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)