Connection Failed – Unable to cast COM object…

 

Make sure you have the correct version of MSSDA loaded on the Events2HVAC server.  Events2HVAC is compiled using the MSSDA component found in MSEA v4.0.