What's the trick to get a microsoft sql connector to work?

SharonM

I've tried everything I can think of and it still rejects my connection. I know that the database is up as I'm currently working in it in SSMS - I added the Domo IP addressed to Azure - so it should allow the connection in. What else do I try?

ArborRose

Sounds like you have a firewall issue. Azure SQL typically use .database.windows.net domain…something like that. And you need to make sure you have the IP addresses used by Domo includes in the Azure SQL firewall rules.

SharonM

Thanks. I added the addresses

is there something else I need to do?

ArborRose

There's also a box for "Allow Azure services and resources to access this server".

SharonM

Thanks I'll try that

SharonM

Definitely getting closer- could it be that we require mfa to get in to the database? and if so - is there a way around that - we use Microsoft mfa

ArborRose

I don't think MFA would be an issue. Are you attempting to connect using the Azure Synapse SQL Connector?

SharonM

No the Microsoft SQL Server one - should I use the Azure one? Thanks for your help - I am totally new to Domo

ArborRose

Yes, I would try the Azure Connector. I have a few things hosted in Azure and it works a bit different than having a normal MS-SQL database.