Home → Problems →

AppVeyor build agent unable to connect to Azure Sql Server Database when running integration tests

• Edit

chris.dunn

17 Jun, 2015 08:00 AM

Hi,

A project of mine has been set-up to run integration tests but it's failing because the build agent is unable to connect my Azure Sql Server database. The error message in the log file shows the IP address of your build agent Azure VM so I *could* add that to the sql server firewall rules but then for all I know the IP is dynamic.

Are the IP addresses for your VM's static? and if so, is there a range of IP's you can give me so I can add this to the firewall?

Cheers

1. Support Staff 1 Posted by Feodor Fitsner on 17 Jun, 2015 01:50 PM

   

   Yes, here it is: http://www.appveyor.com/docs/build-configuration#build-environment

   - Feodor

   • Edit

2. 2 Posted by chris.dunn on 17 Jun, 2015 02:29 PM

   

   Thanks, just what I was looking for.

   • Edit

3. chris.dunn closed this discussion on 17 Jun, 2015 02:30 PM.

4. chris.dunn re-opened this discussion on 17 Jun, 2015 03:05 PM

5. 3 Posted by chris.dunn on 17 Jun, 2015 03:05 PM

   

   Hi,

   The page you directed me to displays the following ranges:

   169.54.128.0/27
   169.54.128.128/27

   My project build was run on a VM with the IP 169.54.128.144 ... I'm no networking expert but this is beyond the range of 0-128? I've not missed anything obvious here am I?

   • Edit

6. Support Staff 4 Posted by Feodor Fitsner on 17 Jun, 2015 04:49 PM

   

   Yes, this is range, so you have to add:

   169.54.128.0-32
   169.54.128.128-159
   

   • Edit

7. 5 Posted by chris.dunn on 17 Jun, 2015 06:09 PM

   

   Thanks. I only just discovered CIDR today as well!

   • Edit

8. chris.dunn closed this discussion on 17 Jun, 2015 06:10 PM.