No ratings

Error when adding new SQL server service instance: ExecuteReader requires an open and available Connection. The connection's current state is closed.




Symptoms


When trying to add a new SQL server service instance, the following error appears:

Validation Error
ExecuteReader requires an open and available Connection. The connection's current state is closed.

Diagnoses


The error only occurs when registering the service instance against certain Databases.

Those Databases having the errors had more items (i.e. Tables, Views, Stored Procedures) than those that didn't have the error.

The error occurs around 30 seconds after the "Add" button was clicked, which is also the default command timeout value.

Resolution

Increase the Command Timeout value from 30 to a larger value (i.e. 300) on the SQL Service Instance configuration page, and then try adding it again.





Version history
Last update:
‎09-12-2016 09:28 PM
Updated by:
Contributors