Zapier Connection Azure SQL

Andrea Neubert 1 Reputation point
2021-04-28T12:37:28.87+00:00

Hello, I want to connect to an Azure SQL database with Zapier. Unfortunately that doesn't work. The IP address or port is inco92162-zapier.jpgrrect. Does anyone know about Zapier? Many greetings Andrea

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-04-29T09:21:52.647+00:00

    @Andrea Neubert Welcome to Microsoft Q&A forums.

    Since this not an issue with Azure SQL Database, I am not very confident you will find many community members that can help you with Zapier.
    You may get better responses on the Zapier Community instead.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

    0 comments No comments

  2. Alberto Morillo 32,706 Reputation points MVP
    2021-04-30T16:40:48.29+00:00

    You cannot rely on the current IP address of the Azure SQL Server. The IP address of your logical server is not static and is subject to change at any time. All connections should be made using the fully qualified DNS name (FQDN) rather than the IP address. Please refer to this documentation.

    Use the credentials of the Server Admin login of the Azure SQL logical server.

    Ping the FQDN name of the Azure SQL server (morillo.database.windows.net for example), It should fail (request time out) but it should bring you the current IP address of the logical server. If you don't see that IP address, then you are facing a DNS resolution issue.

    If that IP address is returned, use telnet command to test you can reach the Azure SQL logical server from your network, for example: telnet 40.38.232.6 1433.

    Make sure you whitelisted the IP address of your organization on the Azure SQL firewall. Please read this documentation on how to add an entry on Azure SQL firewall.

    0 comments No comments