Data Protection for SQL Server requires certain settings in order to perform operations
in a secure environment.
Windows administrator authority is required
for installation. Data Protection for SQL Server must
be registered to the Tivoli® Storage
Manager server and
the appropriate node name and password must be used when it connects
to the Tivoli Storage
Manager server.
In addition, standard Tivoli Storage
Manager security
requirements apply to Data Protection for SQL Server.
Three options are provided when you specify SQL Server
logon information:
- Accept the default sa account and blank 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.
The SQL logon user or Windows user
name must be added to the SQL Server SYSADMIN fixed server role before
it can be used by
Data Protection for SQL Server.