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

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 .

 


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)