KB ID 0001415
I was doing some RDS work for a client today, and it would seem that at some time in the past their RDS Licensing server had died, it had been replaced, and everything was working OK. But when I was adding roles to the new servers, this kept popping up;
The following server in this deployment are not part of the server pool
The servers must be added to the server pool.
I could have ignored the error and finished the job, but things like this remaining ‘unfinished’ really wind me up. So I thought I’d sort it out.
At first I thought I could just dive into either ADSIEdit or ‘AD Sites And Services’, make a quick change and everything would be fixed. That revealed that the site licence server was set to a server that also didn’t exist! (So I fixed that, still the problem remained).
So if all else fails then use PowerShell right?
Error: Object Reference not set to an instance of an object
After some research I discovered that the RDS servers are stored in a database, (Windows Internal Database) on the connection broker(s). So you need to download the ‘SQL Management Studio’ software on your connection broker(s). Then ‘Run As’ administrator.
Connect to, “\\.\pipe\MICROSOFT##WID\tsql\query“
Under Databases you will find a database called RDCms >Expand that, and drill down to the tables. Locate rds.server. Press the ‘Query’ button > Right click the rds.server table > List top 1000 rows.
Locate your ‘Dead’ server here you can see mine has an ‘Id’ of 3. Look in the following tables and make sure there are no references to Id 3. (I didn’t have any, my only reference was in the rds.server table.)
- rds.RoleRdcb (Connection Broker)
- rds.RoleRdls (License Server)
- rds.RoleRdsh (Session Host)
- rds.RoleRdvh (Virtualisation Host)
- rds.RoleRdwa (Web Access Host)
In the bottom of the Query Section enter the following, (as applicable, i.e your column might be ServerId, and your server might be number 123)
delete from rds.server where Id=3
Press ‘Execute’, Close the SQL Manager, repeat on any remaining ‘Session Brokers’. Have a coffee, then try again, the problem should be resolved.
Related Articles, References, Credits, or External Links