none
Duplicate scale-out entries SQL 2008 R2 RRS feed

  • Question

  • We've rebuilt our SSRS Server which was SQL 2008 to SQL 2008 R2 (also 32 to 64 bit OS change).  When I restore the Encryption Keys it adds two server with the same name to the scale-out deployment.  If I try to delete one of them (because it's standard edition) it actually deletes both entries.

    If I try and run "RSKeyMgmt.exe -l" I get an access denied error.  Any ideas?  My login has both Server and SQL Admin rights.

    Friday, September 23, 2011 6:57 PM

Answers

  • Evidently I fixed my problem.  I needed to shift-click and run the RSKeyMgmt.exe as administrator.  Then I ran RSKeyMgmt.exe -l.  Didn't know which ID to delete so thought I'd delete out the servers listed in the scale-out deployment but this time only one deleted and now SSRS is running perfectly.  No idea how I really fixed it, but I'll take it.
    • Marked as answer by Chad Renstrom Friday, September 23, 2011 7:15 PM
    Friday, September 23, 2011 7:15 PM