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

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?

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • 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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Thanks. I added the addresses

    is there something else I need to do?

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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Thanks I'll try that

  • 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

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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

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

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **