SQLsafe 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 SQLsafe.
If you are deploying SQLsafe 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 a SQLsafe component has been installed.
Recommended permissions for trial installations
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. |
Required permissions for production installations
Account | Action | Permissions Required |
---|---|---|
Windows user account |
|
|
SQL Server login |
|
|
Management Service account | Allows the SQLsafe Management Service to access the SQLsafe Repository database. |
|
Backup Service account | Allows the Backup Agent to access the SQL Server instances in your environment. |
|
MSSQLSERVER service | Allows SQLsafe XSP to read and write backup files. | Read and write permission on the volume or share you want to write or read backup files. |
TSM Server | Allows you to configure TSM Server and client nodes for communication. | Administrator privileges within TSM Server. |