How to: Remove ‘old’ RDS server from farm

When you delete a old RDS Session Host server from your environment whitout first deleting the server from your RDS Farm, you’ll receive the following error:

Install SQL Management Studio on your RDS Connection Broker and connect to the following server name:

\\.\pipe\MICROSOFT\##WID\tsql\query

Create a new query:

SELECT TOP 1000 [Id],[Name] FROM [RDCms].[rds].[Server]

Here you can see all your servers in your RDS Farm. Notice the Id of your ‘old’ server. In this example it is server ‘RDS-01’ with ID 2.

Create a new query:

use RDCms;
delete from rds.RoleRdsh where ServerID = ‘2’;

Start Powershell on your RDS Broker server and type:

Get-RDServer

Now you can open your Server Manager again and manage your RDS Farm!