SQL Safe Backup requires specific permissions and rights to successfully execute backup and restore operations. Generally, the rights of the Management Console user dictate the rights available to SQL Safe Backup.
If you are deploying SQL Safe Backup to a non-trusted domain, specify an account with sysadmin fixed role rights for the Management Service and Backup Agent Service accounts, and ensure that SQL Authentication is enabled on each SQL Server instance where the SQL Safe Backup components have been installed. |
Type | Requirement |
---|---|
Windows Permissions | Your Windows logon account has local Administrator permissions. |
SQL Server Privileges | Your Windows logon account is a member of the sysadmin fixed server role on the SQL Server instance. |
Account | Action | Permissions Required |
---|---|---|
Windows user account |
|
|
SQL Server login |
|
|
Management Service account |
|
|
Backup Service account |
|
|
MSSQLSERVER service |
|
|
TSM Server |
|
|
| | | | | | | |