Hello,

I am unable to connect to my SQL Azure server using SQL Management Studio.  I have verified that I have set the firewall of the SQL Azure server to accept connections from my local public IP using the Azure Portal and that I am using the correct login details.

I have troubleshooted the network connectivity and pinging and telneting to the SQL Azure server is falling.  Performing a tracert also shows network connectivity issues.  My SQL Azure server name is nmckjl5i1n.

The exact trace is as follows:

C:\ >tracert nmckjl5i1n.database.windows.net

Tracing route to data.am3-5.database.windows.net [168.61.59.204]

over a maximum of 30 hops:

  1     1 ms    <1 ms    <1 ms  router.belkin [192.168.2.1]

  2     2 ms     1 ms     1 ms  10.56.104.1

  3     4 ms     4 ms     3 ms  host90-152-0-1.ipv4.regusnet.com [90.152.0.1]

  4     6 ms     3 ms     4 ms  10.0.4.5

  5     5 ms     3 ms     4 ms  t2a5-ge1-0-0.uk-glo.eu.bt.net [166.49.170.117]

  6     3 ms     4 ms     3 ms  t2c2-ge13-0-0.uk-glo.eu.bt.net [166.49.135.233]

  7     3 ms     3 ms     3 ms  t2c4-xe-0-0-2-0.uk-lon1.eu.bt.net [166.49.208.69]

  8     3 ms     7 ms     3 ms  t2c3-xe-0-3-3-1.uk-lon1.eu.bt.net [166.49.237.238]

  9    10 ms    19 ms    12 ms  igbtmdistc7503.msft.net [195.66.236.140]

 10    14 ms    15 ms    13 ms  ae3-0.amb-96cbe-1a.ntwk.msn.net [204.152.141.116]

 11    15 ms    11 ms    12 ms  ae5-0.am2-96c-1b.ntwk.msn.net [191.234.81.126]

 12    12 ms    12 ms    11 ms  ae6-0.am3-96c-1b.ntwk.msn.net [191.234.81.197]

 13     *        *        *     Request timed out.

 14     *        *        *     Request timed out.

 15     *        *        *     Request timed out.

 16     *        *        *     Request timed out.

 17     *        *        *     Request timed out.

 18     *        *        *     Request timed out.

 19     *        *        *     Request timed out.

 20     *        *        *     Request timed out.

 21     *        *        *     Request timed out.

 22     *        *        *     Request timed out.

 23     *        *        *     Request timed out.

 24     *        *        *     Request timed out.

 25     *        *        *     Request timed out.

 26     *        *        *     Request timed out.

 27     *        *        *     Request timed out.

 28     *        *        *     Request timed out.

 29     *        *        *     Request timed out.

 30     *        *        *     Request timed out.

Trace complete.

I do not have technical support on my Azure subscription so any help would be appreciated.

Hi trucaspokesmansaidcom

Could you please set the allowed IP rule from '0.0.0.0' to '255.255.255.255' and then try to connect from SSMS? If it works then it should be something wrong with your local public IP.

If it still doesn't work, please try to connect Azure SQL from another network like connecting from home.

Just in case non of the above situation works, please try to create a new Azure SQL and test what's the connection going on to it.

Do not forget to remove the new added allowed IP rule after test.

If you have any question, feel free to let me know.

Thanks for your suggestions Eric,

I attempted added the all IPs rule in the Azure Management Portal but the connection from SSMS is still not working and the TRACERT is still not not completing.  I've also tried to TRACERT from home and it is also timing out.  It appears to be termininating on the Microsoft msn.net network.

I will create a new Azure SQL Database amd see what happens.

Many thanks,

Truc. 

In the end my firewall was blocking outbound connections to port 1433.