SQLServerCentral.com / Reporting Services / Reporting Services / SSRS Report keeps on failing every few minutes / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 18:42:50 GMT20SSRS Report keeps on failing every few minuteshttp://www.sqlservercentral.com/Forums/Topic1463668-150-1.aspxHi,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 processingAn 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.Fri, 14 Jun 2013 10:18:10 GMTsabah_seattle