sql server reporting services: For some reason, our reports will just stop working...randomly.

It basically tells us it can't connect to our record sets. The report works
in the designer.

Also, if we re-deploy the report it starts working! Even if we don't change
anything it sometimes stops. Then, we re-deploy and it works.

What gives?

This is with different users and different reports.

Thanks!

Sorry to bump this but it is really becoming a problem.

At random, our reports just stop working. With different error messages.

Sometimes, it can't find a stored procedure. Sometimes, it can't find a
table. It's like the report is loosing its connection with the server.

I have confirmed the stored procedure/tables/etc are there and working. All
other apps access the data just fine. The newest SP has been installed on
the server.

Any clues?

Here is a copy of the error message:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Customers'. (rsErrorExecutingCommand)
Could not find stored procedure 'dbo.up_get_customer_list_with_All'.

The last line changes. Sometimes it can't find a stored procedure,
sometimes it can't find a table. Once again, I have confimed they are indeed
there and working.

Thanks

-cbmeeks


[quoted text, click to view]