question

ElhadiAIT avatar image
0 Votes"
ElhadiAIT asked ElhadiAIT commented

Remote Desktop Connection Broker HA/ SQL

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.

66484-sqlexpress.png


66526-connectionstring.png


sql-server-generalremote-desktop-services
sqlexpress.png (8.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ElevenYu-MSFT avatar image
0 Votes"
ElevenYu-MSFT answered ElhadiAIT commented

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://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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks Elven, that solved my problem.

Best regards,
Elhadi

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.