SQL Server Instance fails to expand in the selection list, and backups fail with "Unable to attach to a resource."

SQL Server Instance fails to expand in the selection list, and backups fail with "Unable to attach to a resource."

Article: 100003668
Last Published: 2014-06-24
Ratings: 2 3
Product(s): Backup Exec

Problem

Trying to expand the SQL Server Instance in the backup selection list will fail. Any previously created backups will fail with "Unable to attach to a resource."

Error Message

"An attempt to connect to SQL Server has failed. The logon account may have invalid credentials, or the logon account may have been applied to the wrong resource."

Cause

This can be caused by the Backup Exec account not having the correct credentials in the SQL Instance.

Solution

 
 1. Make sure that Backup Exec account has the following server roles & privileges on the SQL server while backing up SQL databases:
  • dbcreator
  • securityadmin
  • serveradmin
  • sysadmin

2. Also add the Backup Exec account to local administrator group on SQL server .

 

 

 

Was this content helpful?