Filters to support High Availability MSSQL

Owned by Agat Support
Last updated: Nov 23, 2022
1 min read

This page is relevant to any filter

Make sure that the Bastion's machine has "Microsoft OLE DB Driver" version 18.1.0 onward as installed program. If not, you can download it from here 

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

It supports TLS 1.2 as well as failover capabilities (high availability)

In the connection string of any filter, you need to change the provider from SQLOLEDB (or SQL Server Native Client 11.0) to MSOLEDBSQL

Then just restart Bastion


More to read:

https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16

https://communities.actian.com/s/article/TLS1-2-compliant-OLE-DB-Driver-for-SQL-Server-just-released

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-client-connectivity-sql-server?redirectedfrom=MSDN&view=sql-server-ver15