all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

Subscription Account Error


Subscription Account Error James U
5/1/2006 7:31:03 AM
sql server reporting services:
I created a report and time based subscription. The report runs at the
designated time, but gets an error:
"'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVICE'. The step failed."

Why does the report try to run as this account when the service runs as a
RE: Subscription Account Error James U
5/8/2006 7:17:02 AM
Let me add a little more. The error is in the Job History Log and gets
generated when the report tries to execute. I am running SQL 2005 on Server
2003 which was upgraded from SQL 2000, which worked perfectly. The only thing
running as NT AUTHORITY\NETWORK SERVICE as far as I can tell is ASP.NET (the
Application Pool).

Any help I can get would be appreciated.

[quoted text, click to view]
AddThis Social Bookmark Button