all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

RS2005 - Report Scheduler Error


RS2005 - Report Scheduler Error Terry
10/27/2005 12:03:01 PM
sql server reporting services:
What does the following error mean and how do I resolve this matter?

ERROR:

'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVICE'. The step failed.


RE: RS2005 - Report Scheduler Error Ryan
11/10/2005 1:50:11 PM
I am also experencing this error when the SQL agent tries to execute the step
to run the AddEvent stored procedure which generates the report. The SQL
agent runs under a domain service account which is sa to the SQL server. It
appears that the default owner of SQL Agent jobs is NT AUTHORITY\NETWORK
SERVICE.

We also have a production server running SQL 2000 reporting services with an
identical security configuration. The jobs are invoked on this server with
no isssues.

It seems that the SQL 2005 Agent service account is unable to impersonate
the local network service.

Please advise,

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