I have a report that includes DataSets pointing to Stored Procedures and three Datasets for date range query. I'm getting the following error when I try to run the report.
"The Server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error."
The store procedures run without issue in SSMS.
I've checked to make sure each SP is using unique #Temp Table names, I have all referenced joins with NO Lock. Each of my Data Parameters are uniquely named (DateRange, DateRangeW, DateRangeY, StartDate, EndDate, StartDateW, EndDateW,....etc.).
We have hundreds of reports running without issue, and I've never encountered this error. It seems kind of ambiguous
Any suggestions on how to fix this or troubleshoot further would be greatly appreciated!!!