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

chris.dunn's Avatar

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

    Feodor Fitsner's Avatar
  2. 2 Posted by chris.dunn on 17 Jun, 2015 02:29 PM

    chris.dunn's Avatar

    Thanks, just what I was looking for.

  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

    chris.dunn's Avatar

    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?

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

    Feodor Fitsner's Avatar

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

    169.54.128.0-32
    169.54.128.128-159
    
  7. 5 Posted by chris.dunn on 17 Jun, 2015 06:09 PM

    chris.dunn's Avatar

    Thanks. I only just discovered CIDR today as well!

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac