SREE_H_FrcSQLEncrypt

  • Article

To use data encryption when connecting to an SQL database (Enterprise Edition)

  1. In the console tree of ISA Server Management, click Monitoring:

    • Expand Microsoft Internet Security and Acceleration Server 2006, expand Arrays, expand Array_Name, and then click Monitoring.

  2. In the details pane, click the Logging tab.

  3. On the Tasks tab, select the appropriate task:

    • Configure Firewall Logging. To configure the Firewall log.
    • Configure Web Proxy Logging. To configure the Web Proxy log.

  4. On the Log tab, select SQL Database.

  5. Click Options.

  6. Select Force data encryption.

Note

To open ISA Server Management, click Start, point to All Programs, point to Microsoft ISA Server, and then click ISA Server Management.

Important

The Remote Logging (SQL) system policy configuration group must be enabled to log to an SQL database.
By default, encryption is enabled for logging to an SQL database, requiring ISA Server to connect to the SQL database over a Secure Sockets Layer (SSL) connection. The SSL connection requires a certificate on the computer running SQL Server. You must also update the trusted root authority on each ISA Server array member to trust the server certificate. For more information, see Best Practices: Logging at the (https://www.microsoft.com/).