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?

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

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

  • ArborRose
    ArborRose Coach

    I wanted to follow-up with a bit more information in case someone reading has trouble with this. An Azure database can be hosted in Microsoft Azure. Or you might have an Azure VM server in the Azure environment, running a Microsoft SQL database.

    I just successfully completed a connection to a MS SQL Database on an Azure VM. My VM is visible to me on "Virtual Machines". That connection was made with the Domo Microsoft SQL Connector. For host, I gave it the IP of the host machine (VM). And the MS SQL account created on the SQL server.

    If my database appears in Azure under the "SQL databases" icon, then it would be an Azure database and should use the Azure Connector.

    image.png



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

Categories