December 22, 2010 at 5:38 am
Just migrated from SQL 2005 to SQL 2008 successfully - apart from fact that reports published on the SSRS won't generate a subscrption (email or to file share).
Subscriptions just don't seem to fire - they appear to have been set up correctly (can see jobs in SQL Management Studio).
No errors in Event log or SQL log.
Can anyone give me a checklist or some pointers please?
Reports on new instance are accesible from our main web application and can be run ok realtime - it's just subscriptions that are preventing us from rolling this out fully.
Thanks.
December 22, 2010 at 7:54 am
Look at the sql Server Agent if it is running find your Subscription and try to run it ReportingService Database is it running succesfully.
December 22, 2010 at 8:30 am
I'll try that thanks. Job agent is running, but worth a try...
December 22, 2010 at 11:51 pm
Maybe some policy in Reporting service and agent running account.You can change the
service accounts to administrator and test it.
December 23, 2010 at 2:40 am
it's trying to run under the TFS (team foundation server) account rather than service or network account, think this may be the problem - will have another look and see if I can change it.
September 11, 2015 at 8:10 am
Verify if the mail profile is setup fine.
Also are there any errors in the report server catalog?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply