Friday, February 20, 2015

Removing server from SSRS 2008 Scale-Out Deployment

While looking the configuration of our SSRS 2008 server, I found that the old SSRS WFE (web-front end) server had been joined to our current SSRS.  I don't know how this happened or why, but wanted to remove it. 

  1. Open command line and go the the path C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\ (on a 64-bit SQL 2008 Reporting Services )
  2. List the report servers currently in the database type the command:

    RSKeyMgmt
    -l
  3. You will see the server listed with their GUID.  Note the GUID of the server that you want to remove.
  4. To remove the instance of the Report server type the command below:

    RSKeyMgmt
    -r
  5. Press Y to remove the server.
  6. Type the command:

    RSKeyMgmt
    -l


    and verify that the server has been removed.


Reference:
http://milehighdba.blogspot.com/2011/06/remove-server-from-ssrs-scale-out.html
https://stevenrobert.wordpress.com/2011/06/27/remove-server-from-ssrs-2008-scale-out-deployment/

No comments:

Post a Comment