No SQL Server Report Subscriptions Run after SQL Server 2005 Upgrade from SQL Server 2000

No SQL Server Report Subscriptions Run after SQL Server 2005 Upgrade from SQL Server 2000

Post by Dwigh » Thu, 28 Dec 2006 01:25:45


Hello,

We had a running instance of SQL Server 2000 SP4 with SQL Server 2000
Reporting Services (SP2 I think) that had several working e-mail report
subscriptions.

Since the upgrade to SQL Server 2005 with SP1 the subscriptions simply
do not run...no errors in the logs under "C:\Program Files\Microsoft
SQL Server\MSSQL.2\Reporting Services\LogFiles".

All of the SQL Server 2005 services are running as LocalSystem except
for Integration Services and Reporting Services, which are both running
as Network Service.

The only place I find any errors at all is in the SQL Server Agent
logs...there are a couple of jobs that are Report Server related...they
both point to some kind of logon problem...'EXECUTE AS LOGIN' failed
for the requested login 'NT AUTHORITY\NETWORK SERVICE'. The step
failed.

What what do I need to do in order to get the unattended subscriptions
running again?

Thanks in advancd,

Dwight