Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This guide is here to help you quickly identify and resolve any common issues you might encounter. Simply browse the sections below to find a solution to your specific problem. If you can't find what you're looking for, feel free to contact our support team for additional help.

ExecuteNonQuery requires an open and available connection

To correct this error the The SQL Server Instance must be online and ready for connections to correct this error. This happens for some of the following reasons:

  • SQLCM cannot connect to a SQL Server instance (repository or audited instance). 
  • Check the following:
    • The repository SQL server is online
    • The CM components (Collection Server and the Agents) are online
    • The audited instances are online
  • The instance could be down.  
  • The user login credentials could be incorrect.




Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse