Showing posts with label bringing. Show all posts
Showing posts with label bringing. Show all posts

Wednesday, March 21, 2012

Migrate or Script Subscriptions and Schedules

I've used RSScripter.exe to move reports and permissions to a new server.
The scripter does not seem to be bringing over subscriptions or shared
schedules.
Is there a good way to migrate subscriptions for existing reports from one
server to the other?It seems the log shows the following error: EXECUTE permission denied on
object 'xp_sqlagent_is_starting'
I've tried running this on the box, under the context of local
administrator, even the domain account running the ReportServer service and
it's still not working.
"Scott" wrote:
> I've used RSScripter.exe to move reports and permissions to a new server.
> The scripter does not seem to be bringing over subscriptions or shared
> schedules.
> Is there a good way to migrate subscriptions for existing reports from one
> server to the other?