Removing SSRS Scale-Out Deployment Servers.. when the Config UI just won't do it

I am currently working on a TFS Upgrade.  We're going from an older TFS 2010 (that I think started life as something earlier than that) up to TFS 2013 (Update 3!).   We're following the ALM Ranger guidance and doing a Migration-based upgrade.  We've got a shiny new SQL Server 2014 with SSRS installed and it's time to migrate the old Reporting database over to the new hardware.  I've taken my backup from the old machines, and restored them to the new machines, then it's on to the SSRS Configuration manager to change databases over.. no troubles.. restore the old Encryption Key... and...  ahh, we find that the SSRS Server gives me this dreaded message when I try to view it:

Scale-out deployment is not supported in this edition of Reporting Services.

Yes, when I changed databases, it brought over the old server to put in the Scale-Out deployment setting.  No trouble! I can go in to the Scale Out Deployment settings through SSRS Configuration Manager and Remove the un-needed server(s)!  Except, no, I can't.. it fails to remove them.  The old SSRS installation is SQL 2008R2, and I don't think my shiny new SQL 2014 server is up to the task of communicating quite perfectly.. I see this when I try to remove one of the old servers from my Scale-Out Deployment "Removing report server <instance id Guid> from the web farm of the local instance.   --- The task failed". Great!

When looking in the Tell me more about this problem link I get some details like this:

Microsoft.ReportingServices.WmiProvider.WMIProviderException: No report servers were found. ---> System.Management.ManagementException: Invalid namespace

   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)

   at System.Management.ManagementScope.InitializeGuts(Object o)

   at System.Management.ManagementScope.Initialize()

   at System.Management.ManagementScope.Connect()

   at ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String machineName)

   --- End of inner exception stack trace ---

Well I HAVE to get it out of there somehow!  A little research, and a lot of asking for help, and a tip comes that I should try to use the command line to get that done.

Reading the MSDN Page Add and Remove Encryption Keys for Scale Out Deployment gets me what I need:

rskeymgmt -r <installation ID>

You can get the <installation ID> part of that from logging in to the machine you want to remove, and finding it in the rsreportserver.config file.  Or, WAY more easily, the error screen on the Configuration Manager when I tried to remove server also provides the Instance ID for me! 

Logging in to the SSRS Server, firing up the command prompt and running the command gave me no troubles.  The servers were removed from my Scale-Out Deployment, and my Report Server migration piece is crossed off!

Running BlogEngine.Net on a GoDaddy site

So I thought I'd post a little something about getting this blog up and running.  I chose to use BlogEngine.Net based on the recommendations of some colleagues, and because it had a strong set of features and it is written in .Net, which I have familiarity with.  So that's great.  I chose to set up a hosting account with that company famous for their sponsorship of the #10 NASCAR car and for their Super Bowl ads, GoDaddy. 

GoDaddy offers BlogEngine.Net as one of the applications that they can install.  That worked smoothly.  I set up a sub-domain and installed BlogEngine.Net in to the root of the new sub-domain site.  Smooth, slick, no trouble.  I waited a few minutes for everything to settle, and was greeted with a  fresh blog site. That's when the fun began.  I found that when I logged in and attempted to do any work under the Administration section I would receive an error that looked like this

Yuck... Clicking any of the Administration settings would result in that error.. Of course the GoDaddy support couldn't help me with the application error... So debug time.  I turned off the Friendly Error Messages in the site's Web.config section and was greeted by a Security Exception:

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

Line 4: @{
Line 5: App_Code.WebUtils.CheckRightsForAdminPagesPages(false);
Line 6: string loginUrl = Href(Utils.RelativeWebRoot + "Account/login.aspx");
Line 7: var userRights = Security.CurrentUserRights().Select(r => r.Flag).ToArray();
Line 8: }

A little help from the BlogEngine.Net forums pointed me to the IIS ASP.Net trust level.  It needed to be set to "Full", but the default was set to "Medium".  I navigated to the settings for my Sub-domain in the Plesk manager that GoDaddy uses, and found the ASP.Net settings:

And Changed the CAS Trust level to Full:

And... TADA! magic, my Admin section was now working without troubles.

From there I was able to go through and set up the blog settings I wanted, uploaded a Theme, and began blogging away!

First Post and other stuff

So This is my new blog, it's going to focus on technical computer/programming/TFS things I run in to in the course of my normal life.. you see I work as a IT Consultant for Polaris Solutions.  In that line of work, there is always something new to learn, try, or break.  So I hope to post some good information here that can help others along the way. 

I have worked as a .Net developer for many years, and more recently have been getting my hands dirty working with Team Foundation Server.  I also like to dabble on the side with some mobile development on my Windows Phone, and have had fun recently fooling around with Azure and how Microsoft's tools there can be leveraged in the Mobile development space. 

So, I think that will give me plenty of areas to draw from.  I am also starting up my training for the Chicago Marathon this October, so I'll try not to let too much complaining about training workouts bleed in to here too much!


<<  January 2021  >>

View posts in large calendar

Category list

Page List

Month List