RDS Farm: High Availability Service Broker Configuration


Before embarking on the configuration of the high availability service several prerequisites are required.

Active Directory Group

Create an Active Directory security group and put the broker broker members.
AD group

DNS registration

Create a common DNS record for broker servers for client configuration.

DNS Records

SQL Server

In order for the servers having the broker service to access the same information, it is necessary to set up an SQL server.

For the realization of this tutorial, I installed a SQL Express 2016 SP2 server, which I configured with remote access. I have also installed SQL Server Mangement Studio to administer the instance.

Configure the connection for brokers servers

1. From SSMS, right-click on Connections 1 and click on New Connection 2 .

2. Click on Search … 1 .
new connection

3. In the object types, add groups 1 then add the server group previously created 2 and click OK 3 .
select group

4. Then go to Server Roles 1 and check dbcreator 2 and click OK 3 to add the connection.
connection configuration

5. The connection is added to the list.
Connection added

Configure the database

1. Right click on Databases 1 and click on New database 2 .
Add database

2. Enter the name of the database 1 and click OK 2 .
Database name

3. The database is added.
DB added

4. Modify the previously created connection for connecting brokers by adding the db_owner role to the database for the broker service.
Edit connection for database

Broker Servers

On each broker server, you must install the native SQL client (sqlncli.msi). It is available in SQL Server sources.

Related Posts

Failover Clustering Windows 2016/2019 – Installation and Configuration

Presentation The failover clustering feature ensures high availability of a service by using multiple servers (nodes) that can make it work. Some examples of services that can be used with the Failove

Force a template for the start menu

Presentation The purpose of this article is to show you how to force a template for the start menu. This change is especially useful for RDS servers to allow users to all have the same environment. Yo

Managing virtual machines in a Windows Server Hyper-V cluster

In this tutorial, we will see how to manage your virtual machines in a Hyper-V cluster using the Cluster Manager console. It is also possible to use the following tools to manage virtual machines with

Scroll to Top