Upload Key File

Key files are required when monitoring a Microsoft SQL Server environment that is configured using the force protocol encryption option, or if you have a Microsoft SQL Server 2005 environment and are using encrypted login sessions with SQL Server mixed authentication. In these cases Guardium must decrypt the database streams, and thus requires the key file for the server.

Since a single Guardium appliance may be monitoring multiple SQL Server instances, you may need to upload multiple key files.

To upload a key file to the Guardium appliance:

  1. Select Administration Console > Upload Key File.

  2. Click the Browse button to locate the key file you want to upload. The key file name must be the fully qualified domain name of the SQL Server. The class file cannot be renamed – it must be created with that name.

  3. Enter the pass phrase in both Pass Phrase boxes.

  4. Click the Upload Key File button. You will be informed of the results of the operation.