Manually removing a SQL Reporting Services instance from a scale out deployment

If you need to remove an instance of SQL Reporting Services from a scale out deployment, but for some reason cannot contact the instance you wish to remove (e.g. the computer has failed or been rebuilt without removing it from the scale out deployment first) you can do this manually from one of the other computers in the scale out deployment by following these steps:

  • To list the announced report servers currently in the database:
    RSKeyMgmt –l
  • This will provide you with a list in the format
    MachineName\Instance – <GUID of the instance>
    Note the GUID of the instance you wish to remove
  • To remove the instance of SQL Reporting Services:
    RSKeyMgmt –r <GUID of the instance noted above>
  • You will be asked to confirm that you wish delete the key you have entered.

Note that RSKeyMgmt.exe is located in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\ on a 64-bit SQL 2008 Reporting Services instance.

6 Replies to “Manually removing a SQL Reporting Services instance from a scale out deployment”

  1. I have a scale out RS on the SQL 2008 R2 cluster. When I upgraded and moved the RS databases from the SQL 2005 to this new instance, it carried the old RS instance. I had to manually to remove the old RS instance. Thanks!

Leave a Reply to Andy Cancel reply

Your email address will not be published. Required fields are marked *