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?
+14Hi
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.
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.
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.
Upgrade to Static IPs:
If using Zapier, switch to a Static IP add-on (Zapier has a Static IP Addresses feature).
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.).
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
