SQL Server Error: SQLServerException. Connection Reset

Issue

Your connector is failing the setup test with the following error:

"java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:40ceb88f-f0cc-4dae-b715-ebf6ded627dd"

Environment

SQL Server connector

Answer

You can take the following troubleshooting steps to help identify what is causing this error:

1. Verify that your SSH Server is correctly mapped to the SQL Server.
2. Check that all steps of the setup guide have been completed.
3. Check that your ~/.ssh folder and files under it have appropriate permissions as listed in our Connection Options documentation section.
   In particular, check the following:
   • ~/.ssh has 700 permissions.
   • ~/.ssh/authorized\_keys has 600 permissions.
4. Is there a restriction (on the SSH host) on the number of connections you can accept for the host?
5. Are there any firewall settings that are limiting/blocking the Fivetran connector access?

If the above steps have not helped you find the cause and a resolution, submit a Support Request.

Cause

This may be caused by issues including:

• Not following the setup test steps
• DNS issue
• Firewall issue
• Other networking issues