TLS Security

When a connector in XLReporter is configured to Microsoft SQL Server, by default it uses the Microsoft OLEDB Provider for SQL Server that is delivered with the Windows Operating System. However, this OLEDB provider does not support TLS 1.2 security which can be configured in later versions of SQL Server.

The telltale sign that TLS 1.2 security is enabled on the database is that when the Test Connection button is clicked, the error returned is: SSL Security error.

To combat this, Microsoft has released the following updated drivers

These can be downloaded from Microsoft’s website and installed. Install either the 32 (x86) or 64 (x64) according to the System Type of the Windows Operating System (32 or 64 bit).

If either of these drivers are installed on the PC, when a connector to SQL Server is configured, it will use the new driver rather than the one delivered by the Operating System.

It is recommended to only install one of these new drivers, both are not necessary.