Report keeps on failing

Question

Report keeps on failing

sabah_seattle

SSC Journeyman

Points: 99
More actions
June 14, 2013 at 8:27 am

#295354

Hi,
I am new in this forum and this is my first topic. 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sql1411 Ten Centuries Points: 1390 More actions · Answer 1

The error can be related with lot of reasons. Would you mind posting the error that you are getting??..... or even an screenshot would probably help us understand more. Besides there is a separate SSRS related forum. You might want to post there as well with the detailed description of the error that you are getting.

sabah_seattle SSC Journeyman Points: 99 More actions · Answer 2

Hello sql1411,

Thanks for responding. Here is the error 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.

Alan Burstein SSC Guru Points: 61136 More actions · Answer 3

sabah_seattle (6/14/2013)
Hello sql1411,
Thanks for responding. Here is the error 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.

This is where I would start:

In Visual Studio look at the properties for your Sales dataset. There it will tell you what Data Source you are using. Open that data source and look at the credentials... That is where it will show what credentials are used to run the report. I think you have "Do not use credentials" selected.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001