# ask-community-for-troubleshooting

David Copeland

03/23/2022, 5:23 PM
Hi all, i'm a BI Analyst just trying out Airbyte for the first time and excited by it as i'm a 1 person team in a small business with multiple data sources 🙂 I have connected a source and i'm now trying to use my local MS SQL Server as a destination but just keep getting this error I have checked the server port is enabled, services are running and added allow connection rule to windows firewall. Any other ideas?

Augustin Lafanechere (Airbyte)

03/23/2022, 5:53 PM
Hi @David Copeland are you running Airbyte locally too? What hostname did you use for your local MS SQL Server?

David Copeland

03/23/2022, 6:26 PM
Hi @[DEPRECATED] Augustin Lafanechere yes I am running Airbyte locally too. I have tried both localhost and my gateway ip as the hostname but neither work
Hi @[DEPRECATED] Augustin Lafanechere i just figured out i needed to use the IPv4 address as the host name
👍🏻 1