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
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