SQL Agent Permissions
Im having trouble with some of my SQL cluster backups. Following the best practice tech article HOWTO21793, seen below, i am confused by the first practice the the third. Please help me understand. To me the first means that i need to add the windows user to the security of the database and assign the System Administrator privilege. The third point seems to say do not add the windows user account to the database security.
1. Ensure that the Windows user account that you use to back up the SQL instances has System Administrator privileges.
2. Ensure that Backup Exec has rights to the following registry keys:
- HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
3. Do not apply the credentials that you use to make SQL backup and restore selections to an actual SQL instance. The credentials that you use to make SQL backup and restore selections must be applied to the Windows computer where SQL is installed.