Page History
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.
Tip | ||
---|---|---|
| ||
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. |
EXECUTE INSERT SELECT UPDATE DELETE | ||||||||||||
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. |