Trouble connecting to MSSQL Server database using MSSQL source connector

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User is facing issues connecting to a MSSQL Server database using the MSSQL source connector and is seeking help to resolve the problem.


Question

Hello everyone,

Please I’m have issues connecting to a MSSQL Server database using the MSSQL source connector.
This is the error message and the log.

Please how do I resolve this?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mssql-source-connector", "mssql-server", "database-connection", "error-message", "log"]
2

I would first check that the server isn’t at its max connections, and also that the port number is correct and that there are no firewall rules preventing a connection.

3

Thank you Justin. Port is correct and the host server for Airbyte has been given access to the database. I will check if it has reached its max connection.