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.