Action Required: Updated firewall settings for database users

[jcadence]

tl;dr If your AppSheet account has a database connected you may need to update your firewall or network security group rules.

In order to enhance the availability and enable future growth of the AppSheet platform, we are adding new IP addresses to the AppSheet service. This change will take place starting on July 15, 2020. Expect AppSheet traffic to originate from the new addresses:

34.87.131.237
34.87.103.64
35.197.185.203
35.244.126.141
35.204.213.55
34.91.161.74
35.222.253.144
34.71.7.214
35.194.89.186
35.245.209.204
35.203.191.15
35.247.56.116

35.240.247.148
34.87.159.166
34.87.233.115
35.244.107.184
35.204.102.20
35.204.159.159
35.239.203.99
35.239.112.17
34.86.96.199
35.245.229.252
34.83.247.7
35.247.40.210

The full list of IP addresses is available here. Please update your firewall settings to ensure traffic to and from those IP addresses is allowed in order to maintain the availability of your AppSheet apps.

[Austin]

Is there any IP’s that were removed or is this only additions @JCadence ?

[Grant_Stead]

@Martin_Pace check this, when we spin up our new DB…

[aeastham]

IF You’re connecting AppSheet to an Azure database server, this script will help to add server level firewall rules.
Connect to the Master Database on the Server using SQL Management Studio, right click on the master database (under “System Databases”) and select “New Query”. Paste in the following and Execute it (note: if you already have the old rules pre July 15 2020 in there, start from rule number 22):

EXECUTE sp_set_firewall_rule @name = N’Appsheet1’, @start_ip_address = ‘20.189.130.98’, @end_ip_address = ‘20.189.130.98’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet2’, @start_ip_address = ‘20.189.132.63’, @end_ip_address = ‘20.189.132.63’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet3’, @start_ip_address = ‘40.67.216.152’, @end_ip_address = ‘40.67.216.152’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet4’, @start_ip_address = ‘40.67.216.182’, @end_ip_address = ‘40.67.216.182’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet5’, @start_ip_address = ‘40.67.219.84’, @end_ip_address = ‘40.67.219.84’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet6’, @start_ip_address = ‘138.91.195.239’, @end_ip_address = ‘138.91.195.239’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet7’, @start_ip_address = ‘20.189.139.27’, @end_ip_address = ‘20.189.139.27’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet8’, @start_ip_address = ‘20.189.138.55’, @end_ip_address = ‘20.189.138.55’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet9’, @start_ip_address = ‘20.189.138.139’, @end_ip_address = ‘20.189.138.139’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet10’, @start_ip_address = ‘20.189.139.109’, @end_ip_address = ‘20.189.139.109’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet11’, @start_ip_address = ‘20.189.139.123’, @end_ip_address = ‘20.189.139.123’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet12’, @start_ip_address = ‘20.189.138.180’, @end_ip_address = ‘20.189.138.180’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet13’, @start_ip_address = ‘20.189.138.40’, @end_ip_address = ‘20.189.138.40’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet14’, @start_ip_address = ‘52.149.110.221’, @end_ip_address = ‘52.149.110.221’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet15’, @start_ip_address = ‘52.149.111.209’, @end_ip_address = ‘52.149.111.209’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet16’, @start_ip_address = ‘52.149.111.211’, @end_ip_address = ‘52.149.111.211’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet17’, @start_ip_address = ‘52.149.111.248’, @end_ip_address = ‘52.149.111.248’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet18’, @start_ip_address = ‘51.144.56.20’, @end_ip_address = ‘51.144.56.20’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet19’, @start_ip_address = ‘51.144.57.117’, @end_ip_address = ‘51.144.57.117’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet20’, @start_ip_address = ‘52.138.118.136’, @end_ip_address = ‘52.138.118.136’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet21’, @start_ip_address = ‘52.138.118.137’, @end_ip_address = ‘52.138.118.137’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet22’, @start_ip_address = ‘34.87.131.237’, @end_ip_address = ‘34.87.131.237’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet23’, @start_ip_address = ‘34.87.103.64’, @end_ip_address = ‘34.87.103.64’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet24’, @start_ip_address = ‘35.197.185.203’, @end_ip_address = ‘35.197.185.203’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet25’, @start_ip_address = ‘35.244.126.141’, @end_ip_address = ‘35.244.126.141’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet26’, @start_ip_address = ‘35.204.213.55’, @end_ip_address = ‘35.204.213.55’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet27’, @start_ip_address = ‘34.91.161.74’, @end_ip_address = ‘34.91.161.74’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet28’, @start_ip_address = ‘35.222.253.144’, @end_ip_address = ‘35.222.253.144’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet29’, @start_ip_address = ‘34.71.7.214’, @end_ip_address = ‘34.71.7.214’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet30’, @start_ip_address = ‘35.194.89.186’, @end_ip_address = ‘35.194.89.186’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet31’, @start_ip_address = ‘35.245.209.204’, @end_ip_address = ‘35.245.209.204’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet32’, @start_ip_address = ‘35.203.191.15’, @end_ip_address = ‘35.203.191.15’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet33’, @start_ip_address = ‘35.247.56.116’, @end_ip_address = ‘35.247.56.116’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet34’, @start_ip_address = ‘35.240.247.148’, @end_ip_address = ‘35.240.247.148’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet35’, @start_ip_address = ‘34.87.159.166’, @end_ip_address = ‘34.87.159.166’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet36’, @start_ip_address = ‘34.87.233.115’, @end_ip_address = ‘34.87.233.115’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet37’, @start_ip_address = ‘35.244.107.184’, @end_ip_address = ‘35.244.107.184’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet38’, @start_ip_address = ‘35.204.102.20’, @end_ip_address = ‘35.204.102.20’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet39’, @start_ip_address = ‘35.204.159.159’, @end_ip_address = ‘35.204.159.159’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet40’, @start_ip_address = ‘35.239.203.99’, @end_ip_address = ‘35.239.203.99’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet41’, @start_ip_address = ‘35.239.112.17’, @end_ip_address = ‘35.239.112.17’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet42’, @start_ip_address = ‘34.86.96.199’, @end_ip_address = ‘34.86.96.199’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet43’, @start_ip_address = ‘35.245.229.252’, @end_ip_address = ‘35.245.229.252’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet44’, @start_ip_address = ‘34.83.247.7’, @end_ip_address = ‘34.83.247.7’;
EXECUTE sp_set_firewall_rule @name = N’Appsheet45’, @start_ip_address = ‘35.247.40.210’, @end_ip_address = ‘35.247.40.210’;