Best answer

Zaps using SQL Server - Port forward restrictions

  • 10 June 2021
  • 3 replies
  • 358 views

I’m with IT support for a new client, and while preparing to transition their network configs to a new firewall, I’ve noticed multiple unrestricted SQL-related port forwards - one of which is labeled “Proposify Zapier”. I need to get more information on how these ports are accessed and if they can be IP-restricted. I would prefer to speak to someone in a non-forum setting if possible, but I’ll take what I can get. Thanks for your time.

icon

Best answer by SamB 1 October 2021, 12:26

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @Clayton George 

You can open a ticket with Zapier Support here: https://zapier.com/app/get-help

Here’s the Proposify Zap app help article: https://zapier.com/help/doc/how-get-started-proposify-zapier

Userlevel 3
Badge +5

Hi @Clayton George, were you able to reach out to support and get help regarding this or do you need further suggestions? Let us know!

Userlevel 7
Badge +11

Just wanted to follow up here as spotted that @Clayton George contacted our Support Team who were able to confirm the static IP address that Zapier makes connections to MySQL/SQL Server databases from. Sharing those details here in case it’s helpful to others as well:
 

“For MySQL or using an SQL server, you'll want to whitelist the following IP address:
54.86.9.50”


More details on connecting with MySQL/SQL Server databases can be found here: Can't Connect to My Database