removing an ssrs instance from a scale-out deployment

Posted by Alex Bransky on Geeks with Blogs See other posts from Geeks with Blogs or by Alex Bransky
Published on Thu, 03 Mar 2011 19:49:30 GMT Indexed on 2011/03/03 23:25 UTC
Read the original article Hit count: 265

Filed under:

If you're like me you had at one time connected one of your Reporting Services instances to a report server database that was already in use by another instance.  This allows the instance to show up in the Scale-out Deployment section of the Reporting Services Configuration Manager.  My problem was that the server that got joined to the original server was no longer available as it had been repurposed, and when I clicked Remove Server to remove it from my scale-out it would fail because it couldn't contact the server.  After searching for a solution for quite some time I decided to look around in the report server database tables, and voila!  All I had to do was remove the old server from the Keys table.  I can't guarantee there won't be any side effects to this method, but it worked like a charm for me.

© Geeks with Blogs or respective owner