Am trying to connect Azure SQL server database with Zapier
Previously it connected fine but has been a while since i have used zapier so connection expired.
I have entered the hostname as the Azure SQL server name (i.e. example.database.windows.net) and using port 1433.
Enter all the credentials but I get the error ‘authentication failed: AppVersions using SQL Zero require static-ip pool types’
Am lost as to how to get past this issue.
Hi
Welcome to the Community.
The authentication issue with your Azure SQL Server connection is likely due to Azure's SQL Zero configuration, which requires static IP pools for specific connections. To resolve this, verify that you're using the correct authentication method (SQL or Active Directory), check firewall settings, and ensure your IP is whitelisted in Azure. If you use a dynamic IP, switch to a static IP pool or upgrade to a higher service tier. You can also set up an Azure Private Endpoint for more secure connections. After updating settings, test the connection in Zapier to ensure it works.
Let me know if you need further assistance.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.