Remote Desktop Connection Broker HA/ SQL

Question

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.

Answer 1

Hi,

1. You should use Microsoft ODBC Driver for SQL Server
2. 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://learn.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.

Answer 2

As far as I know you need for this a SQL Server Always On Availability Group; that's not in the free Express Edition.

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver15

And see also

https://learn.microsoft.com/en-us/windows-server/remote/remote-desktop-services/rds-roles#remote-desktop-connection-broker