Security requirements for backup and restore operations

Edit online

IBM Storage Protect Snapshot for SQL Server requires certain settings to process backup and restore operations in a secure environment.

To install IBM Storage Protect Snapshot for SQL Server, you must have Windows administrator authority. You must register IBM Storage Protect Snapshot for SQL Server to the IBM Storage Protect server and you must use the appropriate node name and password when it connects to the IBM Storage Protect server.

You can specify SQL Server logon information in one of the following ways:

Accept the default sa account and system administrator password. Ensure that you secure your sa login account with a password.
Use SQL user ID security and specify both the SQL user name and password. With SQL user ID security, the SQL Server administrator provides the logon ID and the password that provides access to the SQL Server.
Use a trusted connection and allow Windows authenticate the logon.

You must add the SQL logon user name or Windows user name to the SQL Server SYSADMIN fixed server role before IBM Storage Protect Snapshot for SQL Server can use those credentials.