The error message that I am receiving has got me stumped as it is almost humorous. I am using SSRS 2008r2 and have had quite success with it up until now. The error message I am receiving in is:
ExecuteReader requires an open and available Connection. The connection's current state is closed.
This is ironic as the Data Source test connection was successful and in the Query Designer the Stored Procedure when ran works and returns the Data Set. However when I click the button OK to return to the DataSet Properties window the Stored Procedure seems to be running again and returns the above error. I am stumped and have had no luck researching through Google or using the MSDN forums. Has anyone got an answer and solution as to what might be causing this error?
ExecuteReader requires an open and available Connection. The connection's current state is closed.
This is ironic as the Data Source test connection was successful and in the Query Designer the Stored Procedure when ran works and returns the Data Set. However when I click the button OK to return to the DataSet Properties window the Stored Procedure seems to be running again and returns the above error. I am stumped and have had no luck researching through Google or using the MSDN forums. Has anyone got an answer and solution as to what might be causing this error?