How to use Backup Exec logon accounts for SQL resources

Article:HOWTO24068  |  Created: 2010-01-01  |  Updated: 2011-06-15  |  Article URL http://www.symantec.com/docs/HOWTO24068
Article Type
How To

Product(s)

Subject


How to use Backup Exec logon accounts for SQL resources

To back up SQL, use a Backup Exec logon account that stores the credentials of a Windows user account. The Windows user account must have been granted the System Administrator role on the SQL instance.

In the backup selections list or in the resource credentials list, apply that logon account to the Windows server that SQL is installed on, not to the actual SQL instance.

Figure: Applying Windows user account credentials

Applying Windows user account credentials

If you are using SQL Server Authentication, then add a Backup Exec logon account that stores the credentials of the SQL user account.

In the backup selections list, apply the Backup Exec logon account for the Windows user account to the Windows server that SQL is installed on, and then apply the logon account for the SQL user account to the SQL instance.

Figure: Applying SQL user account credentials

Applying SQL user account credentials

If you use a Backup Exec logon account that does not have the proper rights, you will receive an error message stating that the username and password are invalid.

See About selection lists

See Creating a new Backup Exec System Logon Account


Legacy ID



id-SF700152051_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO24068


Terms of use for this information are found in Legal Notices