The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a cluster management perspective. I’ve previously blogged about Building A Remote Desktop Manager Connection List from the SQL Server Central Management Server (CMS) tables. The RDCMan use case for cluster administration is very useful and it just so happens that I built a similar solution for cluster servers. So, as a follow up here’s a way to auto generate an RDCMan file from a list of clusters, nodes and virtuals.
First create and populate a cluster, cluster_node and cluster_virtual tables defined in the following T-SQL script file:
Note: You’ll need to insert your cluster information into the three tables.
Next use the following T-SQL XQuery to generate the RDCMan XML and save the file as cluster.rdg.
Finally open the cluster.rdg file in Remote Desktop Connection Manager. RDCMan allows to you to have multiple rdg files open at one time which means our previous CMS-based list of SQL Server and our cluster-based list can both be used simultaneously.