I pulled the .rdl...

mysorian (9/5/2013)

---

This is just an experiment I want you to try.

Save your report to the file system. Pick up the report in Report Builder. Now deploy it to the server....

I am unfamiliar with troubleshooting ssrs. . . Do you know of any tutorials or references that might help me decide if it is a memory issue?

Nick

I am passing the same parameter for each of the runs (This is a yearly report).

You were right. For that one row with the lower times was actually an...

Here's the data from execution log. I am not sure what time processing does, but looking at time data retrieval seems to tell me that there might still be a...

Looks like it was the build of that server. I am currently testing my code on our new server (SQL Server 2012) and everything appears to be running great. Thanks...

Well it seems the solution was embarrassingly easy. It turns out that the access database I was connecting was really just a shell with forms and links to another Access...

I don't think my group will want to update the service pack. Since we would have to test all of our DBs and retest them when we upgrade.

For the number...

Edition ProductVersionProductLevel

Standard Edition9.00.3215.00SP2

Nick

Date,Source,Severity,Message

06/18/2012 13:03:00,spid57,Unknown,A fatal error occurred in the .NET Framework common language runtime. SQL Server is shutting down. If the error recurs after the server is restarted<c/> contact Customer Support Services.

06/18/2012...

Thanks for your help. Hopefully our new server will get here soon and I can get some resolution to this issue.

Nick

If the server needs to be rebuild then I am just going to wait on this (Our new server is ordered and hopefully be ready in a month or two)....

I either get a transport error (when the sql server service restarts) or I get this error message:

"Msg 6522, Level 16, State 2, Line 6

A .NET Framework error occurred during...

After more experimenting it appears the I am having issues only when I try to UNION ALL the selects together. If I run them as separate Select statements then it...

Thanks for the info and yea I did find the person on this forum who had the exact same problem as me and I can't believe that the solution is...