Hello Team, We have Airbyte with the source as MSSQL and Bigquery as the Destination for 35 connections. So cron is required for our use case. We now have airbyte 0.40.4, which is not supported by cron. So we used git pull to upgrade to the most recent version (0.40.22). All of the connections have been restored following the upgrade. These connections are worked well on previous version. But now, while Trigger the sync, it throws error like, Failure Origin: source, Message: Checking source connection failed - please review this connection's config. In addition, I was unable to establish a source connection with the SQL server. also, editing of existing source MSSQL source connection also throws an error. Can someone please help me in this?

Can you share the complete log file and server logs to check what is failing?

This is one of my connections log file. this works well on the previous version. after upgradation to the new Airbyte version, it throws an error as the source region fails. (PS: I can't reset the existing MSSQL server connection. but I can do this on my previous version)

Can you confirm the Airbyte containers have access to the MSSQL database? Like

ping

or

telnet?

No i'm not

I recommend to you downgrade the connector version and test again. Connectors shouldn’t be coupled with the platform version.

okay I'll try and let u know thanks