Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I keep getting the below error when trying to connect to any type of Database in AWS:

authentication failed: AppVersions using SQL Zero require static-ip pool types

 

 

I’ve tried using Postgres and MySQL but getting the same error on both. I can connect to both database from n8n and my laptop. I’ve added the Zap IP’s from another article I read (see below):

 

But still cant get it working. Is this an AWS issue? 

Hi ​@adeWoodrup 

Help links for using the apps in Zaps:

 

FEEDBACK

The error message in the image indicates that the app you’re trying to connect (likely a database or app that connects through SQL) requires static IP addresses for authentication, but the connection attempt was made using a non-static (dynamic) IP address.

 

Explanation of the Error:

authentication failed: AppVersions using SQL Zero require static-ip pool types

  • "AppVersions using SQL Zero" refers to a particular setup or version of an app integration (likely in Zapier or another platform) that connects to SQL databases.

  • "require static-ip pool types" means that in order to connect securely, your request must come from a known, fixed IP address—not from a random or dynamic IP.

 

Why This Happens:

SQL servers often restrict access to trusted IP addresses for security reasons.
If your app or integration (e.g., Zapier) doesn’t use a static IP, the connection attempt is blocked by the database server's firewall or authentication system.

 

How to Fix It:

  1. Upgrade to Static IPs:

  2. Whitelist the IP:

    • Once you're using a static IP, add it to your SQL server's IP whitelist (typically in your DB provider or hosting control panel like AWS, Azure, Google Cloud, etc.).

  3. Use a VPN or Tunnel (optional workaround):

    • If static IPs aren’t an option, consider setting up a VPN or reverse SSH tunnel from a server that your database trusts.

 

Reply


Terms & Conditions