Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report keeps on failing every few minutes Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 10:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 1:14 PM
Points: 5, Visits: 5
Hi,

I have created an SSRS report that is called from a stored procedure. The SP is in server A, it query 2 databases. One in server A and the other in server B. A and B are linked servers. The report is running fine both in SSRS and report server. But after every few minutes I get a log on error when I am trying to run the report from SSRS or from the report server. If I manually execute the stored procedure and then try to run the report, it works fine then. Can anyone please help me with this issue? Thanks a lot in advance.

Here is the error that I am getting -
An error occurred during local report processing
An error has occurred during report processing.
Query execution failed for dataset "Sales".
Login failed for user 'NT AAUTHORITY ANONYMOUS LOGON'.

Sales is the name of the main dataset in this SSRS report. It is created from the stored procedure.
Post #1463668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse