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

  • Article ID:100003668
  • Modified Date:
  • Product(s):


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."


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


 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 .




Related Articles

SQL backup completes with AOFO (Advanced Open File Option) exception

Was this content helpful?

Get Support