Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Our SSRS server is not executing a subscription correctly. (Only subscription we have btw)

We created a subscription to export a report as an excel file to the file system.

Tried running the job that gets generated, and this error happens

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

It's not the most helpful in tracking down what exactly it was trying to do.

EDIT

Digging further into the logs I also get these errors

w3wp!extensionfactory!f!7/30/2010-14:29:26:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.

w3wp!extensionfactory!11!7/30/2010-14:34:48:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.

share|improve this question

1 Answer 1

Sounds like you don't have an Execution account setup, and the SSRS service is setup to run under a local account, and the report is setup to use the Windows Auth of the person running the report to log into the database.

Try setting an Execution Account within the SSRS Configuration Manager.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.