The process for setting up a highly available (HA) RD Connection Broker has changed and improved a lot in Windows Server 2012. A wizard has been added to the new server manager to guide you through the process of setting up the HA and adding new RD Connection
Broker servers. This Wiki will take you through the process of deploying active-active HA on the RD Connection Broker.
Before we start to configuration, I’ll quickly sum up the prerequisites. At this point we assume that there is a RD Connection Broker already in place (e.g. during the setup of a quick deployment). The prerequisites for High Availability for the RD Connection
A Microsoft SQL Server with write permissions granted to all RD Connection Broker servers that will be part of the deployment
The Microsoft SQL Server Native Client is installed on all RD Connection Broker servers that will be part of the deployment
Static IP addresses have been assigned to all RD Connection Broker servers that will be part of the deployment
DNS resource records with a single DNS name have been created for all RD Connection Broker servers that will be part of the deployment
Also note that the SQL Server must be at least SQL Server 2008 R2.
Step 1. Preparing the Broker for HA
Before adding a second server with the RD Connection Broker role we need to prepare the current RD Connection Broker for HA. Which means that during this process, the wizard will create a central database on a central MS SQL Server instance and will transfer
the configuration to this database.
We open the Server Manager on the machine that is currently holding the RD Connection Broker Role and we navigate to “Remote Desktop Services” and then “Overview”. We right-click the RD Connection Broker and choose “Configure RD Connection Broker for HA”.
On the "before you begin" screen the previously discussed prerequisites are summed up again, we press “Next”. On the “Configure High Availability” screen we enter the details of the HA setup.
We need to specify the following parameters:
Database connection string
The wizard will use this string to create the database. Pay close attention to the format of the string. Copy the string below and change only replace the <name of SQL server> and <name of database> values.
DRIVER=SQL Server Native Client 10.0;SERVER=<name of SQL server>;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=<name of database>
Folder to store databasefile
Here we need to specify the folder on the SQL Server where we want the databases to be stored. For demo purposes, I placed in C:\RCDB, but in most environments you will probably use an existing HA SQL environment and enter the desired values. Note that
we specify the location for the .mdf as well as the .ldf file, so no separation there. However, you should be able to change that in using SQL Server manager after the installation.
DNS Resource Record name
Here we specify the DNS name that we want this HA RD Connection broker farm be accessible on. For this demo I used rdcb.lab.local
We click “Next” and click “Configure” on the confirmation page. Shortly after that we get the confirm that the configuration has succeeded.
hi followd the manual so good that i can but still got the error, installed sql express on the server but that did not help. got the error. the database in the connection string is not available. does someone got any tips.
At least SQL Server 2008 R2 must be used, and the minimum recommended SQL Server SKU for this is Standard with at least 4GB of RAM.
Thank you sir !. I have been searching for detail info about HA RD connection broker. I have to make a design for 6,000 VDI connection server, and had been studying about the necessity of 1) SQL cluster, 2)SQL, 3)without SQL.
If possible, please let me know if the SQL cluster is necessary for 6,000 VDI support.
Hitachi Systems, Inc. Japan