Need help diagnosing cryptic error when trying to connect stitch to SQL Server instance

warrenlittle — Wed, 09 Oct 2024 18:30:16 GMT

The connection attempt is failing for a certain on-prem SQL Server.

The root error message in the stack is

tap - FATAL [main] tap-mssql.core - Fatal Error Occured - Connection reset ClientConnectionId:bbc760b8-8a57-495e-91e3-c03fe45ecb97
2024-10-09 15:56:23,873Z    tap - ERROR [main] #error {
2024-10-09 15:56:23,873Z    tap -  :cause Connection reset
2024-10-09 15:56:23,873Z    tap -  :via
2024-10-09 15:56:23,873Z    tap -  [{:type

Connection to other SQL Servers in our on-prem have connected without issue.

The error happens in the "prelogin" step

Prelogin error: host 127.0.0.1 port 38051 Error reading prelogin response: Connection reset ClientConnectionId:308aae8b-0ba0-4a4d-9fdc-d55f8e0f1090

topic Need help diagnosing cryptic error when trying to connect stitch to SQL Server instance in Stitch

Need help diagnosing cryptic error when trying to connect stitch to SQL Server instance