Prerequisites

Edit online

With Data Protection for SQL Server, you can back up and restore SQL Server data and protect your SQL Server environment.

Security requirements for backup and restore operations

Edit online

Data Protection for SQL Server requires certain settings to process backup and restore operations in a secure environment.

To install Data Protection for SQL Server, you must have Windows™ administrator authority. You must register Data Protection 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 Data Protection for SQL Server can use those credentials.