Skip to main content
Connection Issues (Add-on)

How to resolve errors in establishing a connection

Sahar Ghafari avatar
Written by Sahar Ghafari
Updated over 4 years ago

Note: Many connection issues are due to your databases firewall. If you're having trouble connecting, we highly recommend using our web app because you don't need to whitelist any IP addresses to get started.

  1. SeekWell uses JDBC to connect to your database

  2. You'll need to make your database available to Google's IPs, here are the ranges (source). The last IP is an address dedicated to SeekWell on Google's infrastructure that is used for scheduling and Postgres support.

  3. Here's an example of how an AWS security group would look for SQL Server:

  4. You can paste the string below into one box on AWS and it will automatically create the ranges you need:

64.18.0.0/255, 64.233.160.0/255, 66.102.0.0/255, 66.249.80.0/255, 72.14.192.0/255, 74.125.0.0/16,173.194.0.0/255, 207.126.144.0/255, 209.85.128.0/255, 216.239.32.0/255, 35.193.207.79/32, 35.239.74.213​/32

If you're not using Google Cloud SQL, you also need to include all the IP's between 0 and 255.

64.18.0.0 - 64.18.15.255
64.233.160.0 - 64.233.191.255
66.102.0.0 - 66.102.15.255
66.249.80.0 - 66.249.95.255
72.14.192.0 - 72.14.255.255
74.125.0.0 - 74.125.255.255
173.194.0.0 - 173.194.255.255
207.126.144.0 - 207.126.159.255
209.85.128.0 - 209.85.255.255
216.239.32.0 - 216.239.63.255


​

Here's an example with MySQL on AWS:

  1. You may want to create a new user if your database has personal information (e.g. customer names and addresses). You can grant this new user access to just the necessary data

  2. If you are trying to access a local database (i.e. on your computer), check out this Stack Overflow answer

Did this answer your question?