Configuring the Auditor SQL Server Connection Using TLS 1.2
Overview
This article describes how to configure Netwrix Auditor and SQL Server to communicate via a secure channel using TLS 1.2. For background on TLS 1.2 and SQL Server compatibility, see TLS 1.2 Support for Microsoft SQL Server ⸱ Microsoft. If you encounter the following error when using the Search function in Netwrix Auditor, follow the instructions below:
Sql Server error occurred (18, [DBNETLIB][ConnectionOpen (SECDoClientHandshake().]SSL Security error.)
Instructions
-
Enable TLS 1.2 on both servers. Use the Microsoft guide to configure it: Enabling TLS 1.2 ⸱ Microsoft.
-
Ensure the Netwrix Auditor host trusts the certificate used for the connection.
-
Ensure the Auditor host has one of the following drivers installed, listed in order of preference:
- Microsoft OLE DB Driver 19 for SQL Server
- Microsoft OLE DB Driver 18 for SQL Server
- SQL Server Native Client (SNAC), version 2011.110.7001.00 or later
NOTE: Microsoft deprecated SQL Server Native Client, including SQLNCLI and SQLNCLI11, and removed it in SQL Server 2025.
-
If the required driver is not installed, download and install the Microsoft OLE DB Driver for SQL Server ⸱ Microsoft.
-
Restart the Netwrix Auditor Archive Service.