question

NiehusHaraldGERenewableEnergy-4948 avatar image
0 Votes"
NiehusHaraldGERenewableEnergy-4948 asked KarlieWeng-MSFT answered

Issues with Remote Desktop Connection Broker High Availability on Windows Server 2016

Hi all,

I'm having troubles configuring RD Connection Broker High Availability on Windows Server 2016.

The initial setup on the first Connection Broker worked well, using a shared database server configuration. I am following steps outlined in this guideline: rds-connection-broker-cluster

However, if I'm now trying to add the second Connection, I receive the error message down below. When setting up an ODBC data source on the affected Connection Broker server, using the very same settings from the Connection String I used in the HA-Setup, the connection to the SQL Server and database works just fine, so it's neither a connectivity/firewall issue, nor authorization issue.

Any idea, what I might missing?

Thanks,

Harald

199733-clipboard02.png


windows-serverremote-desktop-services
clipboard02.png (43.8 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.

1 Answer

KarlieWeng-MSFT avatar image
0 Votes"
KarlieWeng-MSFT answered

Hello @NiehusHaraldGERenewableEnergy-4948

I deployed my RDCB HA environment according to this article: Remote Desktop Services 2016, Standard Deployment – Part 6 – RD Connection Broker High Availability .

Please check the prerequisites mentioned:

  • Be sure to add second connection broker to All Servers in Server Manager (on your primary RDCB) so that you can manage it from there.

  • Create Active Directory Security Group and add all your Connection Broker servers to it. We need this group to be able to convert the RD Connection Broker to a highly available RD Connection Broker.

  • Configure the DNS Round Robin using the IP address’s of the Connection Brokers.

  • SQL server is a must. I will run this on SQL 2016. Be sure to pre-create a folder to store the SQL database files on SQL server if you are not planning to use SQL default path. Give RD Connection Brokers full access on the folder.

  • Ensure that all RDCB Servers have the SQL Server Native Client Installed



Best Regards
Karlie


If the Answer is helpful, please click "Accept Answer" and upvote it.


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.