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

SharonM
SharonM Member
in Connectors

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?

Answers

  • ArborRose
    ArborRose Coach

    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! **

  • SharonM
    SharonM Member

    Thanks. I added the addresses

    image.png

    is there something else I need to do?

  • ArborRose
    ArborRose Coach

    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! **

  • SharonM
    SharonM Member

    Thanks I'll try that

  • SharonM
    SharonM Member

    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
    ArborRose Coach

    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! **

  • SharonM
    SharonM Member

    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

    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! **

Categories