Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time.

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.

Posted on Thursday, March 3, 2011 7:49 AM all tech stuff , SQL Server | Back to top


Comments on this post: removing an ssrs instance from a scale-out deployment

# re: removing an ssrs instance from a scale-out deployment
Requesting Gravatar...
The correct way to do this is by using rskeymgmt from the Administration Tools.

rskeymgmt -r <installationID>

installationID can be found by viewing the Report Server databaser Keys table.
Left by Johannes on Nov 16, 2011 12:50 AM

# re: removing an ssrs instance from a scale-out deployment
Requesting Gravatar...
I had to use this method when the RSKeyMgmt method did not work. Thank you for this solution!
Left by Kenney on Jul 02, 2014 12:46 PM

# re: removing an ssrs instance from a scale-out deployment
Requesting Gravatar...
Thanks for the tip, it helped me too.
Left by Mahesh on Aug 07, 2014 5:46 AM

# re: removing an ssrs instance from a scale-out deployment
Requesting Gravatar...
I had a named instance so I had to use

rskeymgmt -r <installationID> -i <InstanceName>

Once I brought in a database with a difference named instance, and I changed the instance in the KEYS table to the installed instance on the Report Server and then used the command above.
Left by Richard Uglum on Jul 06, 2017 4:35 AM

Your comment:
 (will show your gravatar)


Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net