SOLVED: How To Manually Remove Server Server from Remote Desktop Services

Many people say they cannot remove an RD Session Host Server or RD Session Gateway Server or RD Licensing Server because RDS has a limitation that Microsoft still has not accounted for. If a server that was previously added to your Remote Desktop Services Manager configuration is removed (or disabled) in Active Directory, it blows up your RDS with:

The following servers in this deployment are not part of the server pool. The servers must be added to the server pool.

How To Add A Server To Server Pool

1. Launch Server Manager
2. Expand ALL SERVERS
3. Click MANAGE (top right)
4. Click ADD SERVERS
5. Enter the host name of the server you want to add

If however, the server has been removed from Active Directory, you have a problem because there is no GUI method to remove a server from an RDS pool if it is already out of AD. Fortunately the solution looks an awful lot more difficult that it really is.

How To Manually Remove A Server From RDS

In short, use SQL Server Management Studio (SSMS) to delete the server tied to RDS that has been removed from Active Directory. Here are the steps… not hard, but read carefully:

1. Open the Windows Internal Database with SSMS
   1. Download SQL Server Management Studio directly from Microsoft HERE (SSMS)
   2. Install SSMS on the RDS Manager server
      • This is a click NEXT installation but it takes some time
   3. Reboot
      • No, it will not work without a reboot – I have tried more than once 🙁
   4. RIGHT CLICK on SQL Server Management Studio and select RUN AS ADMINISTRATOR
      1. If you don’t RUN AS ADMIN you will see:
         Login failed for user ‘XXXXX\YYYYYYY’. (Microsoft SQL Server, Error: 18456)
   5. Connect to \\.\pipe\MICROSOFT##WID\tsql\query
      1. leave the default WINDOWS AUTHENTICATION
      2. If that does not work your Windows Internal Database might be at \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
2. Backup the RDS database
   • If you don’t know how to do take a SQL backup, look at this screen shot
3. Delete the problematic RD server:
   1. Expand DATABASES > RDCms (or whatever yours is named) > TABLES
   2. RIGHT CLICK on rds.Server and select EDIT TOP 200 ROWS
   3. Find the name of the server you want to remove and:
      1. Take note of the ID (I just take screen shot)
      2. RIGHT CLICK on the row and select DELETE
4. Expand DATABASES > RDCms (or whatever yours is named > TABLES
   1. RIGHT CLICK on rds.RoleRdvh and select EDIT TOP 200 ROWS
      • If the offending server ID (from step 8.1 above) is still in that list, RIGHT CLICK on the row and delete it
5. Launch Server Manager and confirm it looks good
   • A reboot is NOT required

Here are the steps in screen shots:

---