Add RD Connection Broker high availability for RDS deployments of Windows Server 2016

According to the following overview, I briefly wrote the RDS Add RD Virtualization Host, the following is a brief introduction of the high availability of RD Connection Broker, slowly improve the entire RDS deployment, please look forward to it!

Theme

• Deployment environment
• Prerequisite
• Configure High Availability
• Add Server

Deployment environment

RD Connection Broker I am also using Windows Server 2016 here, only the RDCB server is described here

numbering	Server name	IP Address	Operating System
001	RDCB1	192.168.1.205	Windows Server Datacenter Evaluation
002	RDCB2	192.168.1.206	Windows Server Datacenter Evaluation

Prerequisites 1, add RDCB1 and RDCB2 to the domain. 2. RDCB configuration in the domain when high availability deployment

Go to the AD1 server and open "Active Directory Users and Computers"

Right-click the "contoso.com" Domain name, "new"-"organizational unit"

Run the New Organizational Unit wizard, enter the name of the organizational unit: GROUP, click OK

Click Group This organizational unit, right-click Organizational Unit-NEW-group

Run the wizard for the new group, set the name of the group, click OK

Then there will be "RDCB computer" in group.

Double-click the "RDCB Computer" group to open the properties of the "RDCB computer" group

In the RDCB computer group, click Members, add members, add RDCB1 and RDCB2 to the two computers, and then click OK

3. RDCB database configuration for high availability deployments

To configure the high availability of RD Connection Broker, you must have a SQL Server server, as described in "Deploying SQL Server"
Open Microsoft SQL Server managerment Studio 17

Open Microsoft SQL Server managerment Studio 17, click Connect

After entering the database, right-click on "Database"-"New Database"

Set the database name, click OK

Expand Security-Login name, right-click Logins-New login name

Set the login name and click "Search"

Select the RDCB computer this group created in AD, click "OK"

Login settings complete, set default database to RDCB, default language: 中文版

Click "Server Role" to tick the dbcreator

Click "User Mapping", "RDCB" tick, corresponding membership tick (db_owner and public tick), set to complete "OK" can

4. Install SQL Server client on RDCB server

Here to RDCB1 and RDCB2 install SQL Native Client software at the same time, have the latest installation of the latest, we install here
SQL Native Client 11
Open the SQL Server Client installation package path, right-click Install

Direct point "Run"

Direct point "Next"

Select: I agree to the terms of the License agreement, click "Next"

Select the function to install both the client component and the SQL Server Native Client SDK, click "Next"

Here, click "Install".

SQL Server Client installation complete, point "done"

5. Configure the ODBC data source on the RDCB server

Set up ODBC data sources on both RDCB1 and RDCB2
Click "Start"-"Windows Management Tools"-"ODBC data source (64-bit)"

Open the ODBC Data Sources Window

Click "Add", select "SQL Server Native Client 11.0", click "Finish"

Create a new data source for SQL Server, set the name and connection server computer name for the database, and click Next

Verify the login ID, select default, point to "next"

Tick "Change default database to" and select "RDCB" and click "Next"

Direct point "Done"

Here "OK" can

So I'm going to add it.

A shared folder is created on the disk of the database server to hold the RDCB database file

RDCB server in this folder must have read and write permissions, then we add RDCB Computer group to the RDCB folder's permission group, and give read and write permissions, and then "OK" to complete

6. Configuring DNS Loops

Open the DNS server on the DC domain control server and expand the domain name folder to the forward lookup zone

We know RDCB1 's ip:192.168.1.205,rdcb2 ip:192.168.1.206 to add this two RDCB to the loop
Right-click the domain point "new host"

Set the host name and IP address, set RDCB1 IP here, click "Add Host"

In Add RDCB2 IP, click "Add Host", then click "Finish" to

At this point we can see two newly added HARDCB hosts in DNS and use the IP of RDCB1 and RDCB2 so that the DNS loop is complete

Right-click the "Properties" of DC1 in DNS, at the point "advanced" to see if the loop is enabled, not enabled to tick before "Enable loop", then "OK"

Configure High Availability

Open Server Manager-Remote Desktop Services-Overview and you can see the following RDS overview diagram

Right-click Rd Connection Broker, click Configure High Availability

Run the Configure high availability of RD Connection Broker Wizard

Choose the default option here and click "Next"

Configuring High Availability
DNS name of the RD Connection Broker cluster: HARDCB.contoso.com (which we set in DNS)
Connection string: Driver=sql Server Native Client 11.0; Server=<sqlserver name >; Trusted_connection=yes; App=remote Desktop Services Connection broker;database=< to establish the name of the database > (SQL Server Native Client 11.0 only) Server client)
folder for storing database files: F:\RDCB (This is the shared folder we set up in the SQL Server server)
Set completion point "next

Confirm the configuration you just made, click "Configure"

Configure the high availability of the RDCB connection agent is complete, point "off"

Add Server

When you add an RD Connection Broker server, take a look at the permissions of SQL Server, open the SQL Server Managerment Studio database management tool, go to the database, expand Security- Login name ", find" CONTOSO\RDCB computer "This user, right-click on" Properties "

Open the RDCB computer login property, point to "user mapping", found RDCB database is not checked, and do not have permissions, this is because we configured the RD Connection Broker when the string set to reset it, then we need to add the permissions to add a new RD Connection Broker server, Otherwise it will be an error.

Then we tick the "RDCB" database, "db_owner" and "public" in the database role membership, and then "OK".

To add the RD Connection Broker server.
Open Server Manager-Remote Desktop Services-Overview, right-click Rd Connection Broker, click Add RD Connection Broker Server

Run the "Add RD Connection Broker Server" wizard, point to "next"

Move the computer name of the RD Connection Broker server that you want to add from the server pool to the selected computer, and then click Next

Confirm configuration, point "add"

adding RD Connection Broker Server, installation progress as follows

Here you can see that the Add status is "Success", click "Close" to

So we can see in the overview of the deployment server to the right of the newly added RDCB2 is the RD Connection Broker Server, the RD Connection Broker server is added completed.

Add RD Connection Broker high availability for RDS deployments of Windows Server 2016