April 23, 2013 at 11:15 am
We are moving to a new data center. We have RS install on appweb server that points to different sql server for Reportserver and Reportservertempdb. So, We created a new virtual appweb server and new physical database sql server 2008 r2 at new DC. I did a fresh install of new reporting services 2008 r2 on appweb server. I backed up and restored Reportserver and reportservertempdb dbs from old 2005 sql server to new 2008 r2 database server.
During new RS configuration, I pointed databases to the new restored databases and restored encryption keys. When launched reporting services URL, it works fine.
I stopped and restarted reporting services after configuration.
However, I am not seeing any single job created on new database server. Old server had 20 jobs.
How do I get these subscriptions back to the new install? I thought this should be created with migration and I do not have to do anything.
One odd thing I had to do during config was that:
In scale-out deployment tab in RS configuration, it was showing both the new and old appweb server name as status joined. I was unable to remove the old server name by clicking 'remove server' there. So, I deleted old server name from keys table in Reportsserver as suggested by some forums to have a clean installation. Does it have anything to do with jobs not created?
What do I need to do now to get subscripts jobs created. Ther eare only 20 jobs here but another RS server has over 800 subscriptions that I can not mess up. So, need to find the issue and correct it before I can move on to the another RS instance.
We are under severe time crunch. I apprecite your help.
Thanks,
April 24, 2013 at 6:43 am
Duplicate post. Please post answers in this post
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
April 24, 2013 at 7:44 am
Sorry. I posted it twice. Only 12 views in RS forun and 59 views here. Regardless there are 0 answers..
June 12, 2015 at 8:42 am
Hey - Did you get the answer. Please reply incase you find any workaround.
Thanks and Regards
Piyush Dhyani
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply