Hi evryone,
I want to configure RDCB HA, i have RDS Farm on windows server 2019, and SQLEXPRESS 2019 data base.
Does anyone know wich version of client native should i use, and the correct connection string ?
Firewall is disabled.
Best regards.


Hi evryone,
I want to configure RDCB HA, i have RDS Farm on windows server 2019, and SQLEXPRESS 2019 data base.
Does anyone know wich version of client native should i use, and the correct connection string ?
Firewall is disabled.
Best regards.


Hi,
You should use Microsoft ODBC Driver for SQL Server
The connection string should be: DRIVER=ODBC Driver 17 for SQL Server;SERVER=<name of SQL server>;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=<name of database>
Please refer to below article for details of SQL version compatibility and Connection string details:
https://docs.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver15#sql-version-compatibility
Thanks,
Eleven
If the Answer is helpful, please click "Accept Answer" and upvote it. Thanks.
As far as I know you need for this a SQL Server Always On Availability Group; that's not in the free Express Edition.
And see also
10 people are following this question.