January 11, 2012 at 12:09 pm
My apologies for the confusing subject line, but here's the deal: our current production SQL 2005 databases and SSRS instance are on the same machine. We are migrating the databases to new hardware, which when in production, will have the existing server's name and IP address. The SSRS instance (Report Manager and Report Server) are staying behind on the old hardware, to remain in place as a now stand-alone SSRS instance. The old hardware will receive a new name (and IP address).
My question is: how do we preserve our Report Manager subscriptions? Is there any location within the ReportServer database or the various .config files that references the Report Server by name? We realize we will have to modify the deployment path in Visual Studio to re-publish any existing reports, but are hoping to avoid having to re-create dozens of SSRS subscriptions with parameters, credentials, etc.
Thanks in advance for your advice.
-- Ian
January 12, 2012 at 8:50 am
I've never done this so I can't tell you what the impact will be. I just know if I were doing this I'd prefer to leave the Report Server with the original name/IP and give the new server a new name and IP address. I think it'll be easier to re-point the applications to the new server than reconfigure everything on SSRS.
I'd also recommend that you start using DNS Aliases (CNAMEs) for you databases. You can do one for every application and then if you migrate to a new server all you have to do is change the DNS alias for that application. Here's a link [/url]about this.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply