{"id":7276,"date":"2010-03-22T00:00:00","date_gmt":"2010-03-22T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/sql-azure-connectivity-troubleshooting-guide"},"modified":"2025-09-11T09:39:43","modified_gmt":"2025-09-11T16:39:43","slug":"sql-azure-connectivity-troubleshooting-guide","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/","title":{"rendered":"SQL Azure Connectivity Troubleshooting Guide"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">[This article was contributed by the SQL Azure team.]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error messages that you would see while connecting to SQL Azure as listed below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 &#8211; An existing connection was forcibly closed by the remote host.)<\/li>\n\n\n\n<li class=\"wp-block-list-item\">System.Data.SqlClient.SqlException: Timeout expired.\u00a0 The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Error: Microsoft SQL Native Client: Unable to complete login process due to delay in opening server connection.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;<\/h3>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-1-verify-azure-firewall-settings-and-service-availability\">Section 1: Verify Azure Firewall Settings and Service Availability<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Login to your SQL Azure portal, Select your project and then switch to the Firewall setting tab. Verify that the SQL Azure firewall is configured to allow remote connections from the IP address(es) that you will be connecting from:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\" alt=\"screenshot of a &quot;Table 2&quot; showing a Data table for Annual Cost Estimates\" title=\"clip_image002\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When a computer attempts to connect to your SQL Azure server from the Internet, the SQL Azure firewall checks the originating IP address of the request against the full set of firewall settings. If the IP address of the request is not within one of the ranges specified the connection attempt is blocked and does not reach the SQL Azure server. Blocking by the SQL Azure firewall is usually self evident because the service returns a specific error message similar to the one below:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">C:&gt;SQLCMD \u2013U&lt;user&gt;@&lt;server&gt; -P&lt;password&gt; -S&lt;server&gt;.database.windows.net<\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Cannot open server &#8216;ljvt54v9zo&#8217; requested by the login. Client with IP address &#8216;131.107.0.111&#8217; is not allowed to access the server. To enable access, use the SQL Azure Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Reference: SQL Azure Firewall &#8211; <\/em><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ee621782.aspx\"><em>https:\/\/msdn.microsoft.com\/en-us\/library\/ee621782.aspx<\/em><\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">2. On the Databases tab of your portal, select the database that you are trying to access and click the Test Connectivity button. This will prompt for your username and password to use when connecting.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Note: If the Microsoft Services firewall isn\u2019t enabled you must enable it and wait up to 5 minutes for the firewall setting to take effect. If you get a failure sooner than 5 minutes then it isn\u2019t a valid test of whether the service is available.<\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">a. If the connection succeeds the backend SQL Azure services are available and your server and database is online. Proceed to Section 2.<\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">b. If the connection fails, note the Location listed for your server and check the SQL Azure service status for this location in the Azure Services Dashboard. In the event of a known outage you will be able to find more information there. If the dashboard does not reflect an outage you may call Microsoft at 1-800- 642-7676 to report the issue and obtain assistance.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Reference: How and when to contact Microsoft Customer Service and Support &#8211; <\/em><a href=\"https:\/\/support.microsoft.com\/kb\/295539\"><em>https:\/\/support.microsoft.com\/kb\/295539<\/em><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-2-verify-that-you-can-reach-our-virtual-ip\">Section 2: Verify that you can reach our Virtual IP<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Open a command prompt window and use the PING command to confirm that name resolution successfully translates your logical server name to an IP address. The \u201cRequest timed out\u201d message shown below is expected because SQL Azure will never respond to ping requests.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">C:&gt;ping &lt;myserver&gt;.database.windows.net<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Pinging data.sn1-1.database.windows.net [65.55.74.144] with 32 bytes of data:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Request timed out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Request timed out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Request timed out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Request timed out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ping statistics for 65.55.74.144:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">a. If the server name resolves to an IP address, note the value and proceed with step 2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">b. If this step fails, contact your network administrator or Internet service provider for assistance with fixing your name resolution problem.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. From your command prompt window, try to telnet to port 1433 using the IP address returned in the prior step. This will test whether there are any firewalls\/routers blocking traffic to port 1433.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">C:&gt;telnet 65.55.74.144 1433<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Connecting To 65.55.74.144&#8230;<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">a. If Telnet is successful, the window will change to a completely blank screen. Exit and proceed to the next step.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">b. If it is not successful, capture the output and move to step 4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Reference: Telnet Troubleshooting Guide &#8211; <\/em><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/cc753360(WS.10).aspx\"><em>https:\/\/technet.microsoft.com\/en-us\/library\/cc753360(WS.10).aspx<\/em><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. From your command prompt window, repeat the test trying to telnet to the DNS name instead of the IP address.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">C:&gt;telnet &lt;myserver&gt;.database.windows.net 1433<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Note: If Telnet is not part of your default windows installation, you may enable it from Add\/Remove Windows Components.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Use the tracert utility and capture the output showing the intermediate steps taken while trying to reach the server. This information will be useful if a network engineer is needed to troubleshoot the issue.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">C:&gt;tracert 65.55.74.144<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tracing route to 65.55.74.144 over a maximum of 30 hops<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1 2 ms 1 ms 1 ms 192.168.0.1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2 6 ms 5 ms 5 ms 10.33.34.50<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3 5 ms 4 ms 5 ms 4-1-753.DLLSTX-LCR-07.verizon-gni.net [130.81.107.26]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4 8 ms 5 ms 5 ms so-6-2-0-0.DFW01-BB-RTR1.verizon-gni.net [130.81.28.208]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 44 ms 43 ms 44 ms so-11-0-0-0.LCC1-RES-BB-RTR1-RE1.verizon-gni.net [130.81.17.40]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6 49 ms 44 ms 44 ms so-6-0-0-0.ASH-PEER-RTR1-re1.verizon-gni.net [130.81.10.90]<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Reference: How to Use TRACERT to Troubleshoot TCP\/IP Problems in Windows &#8211; <\/em><a href=\"https:\/\/support.microsoft.com\/kb\/314868\"><em>https:\/\/support.microsoft.com\/kb\/314868<\/em><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-3-not-reaching-the-virtual-ip\">Section 3: Not Reaching the Virtual IP:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you encountered difficulties in Section 2 then you are not reaching the VIP and are instead being blocked between your client and the VIP. The below steps may be helpful, but at this point a network investigation by your ISP or network engineer is required<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Many firewall products allow individual users and domain administrators to block or restrict outbound access on a specific port and or destination IP address. Therefore it is necessary to check the outbound rules that are defined on the local machine as well as any routers or proxies that are in the network path. Rules must allow outbound access on port 1433 to destination IP address range 65.55.*.*. Most firewalls also allow the specification of DNS names to allow. Network products that might block access include:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-windows-firewall-on-the-local-machine\">1. Windows Firewall on the local machine<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><em>Frequently Asked Questions &#8211; <\/em><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb736261(VS.85).aspx\"><em>https:\/\/msdn.microsoft.com\/en-us\/library\/bb736261(VS.85).aspx<\/em><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Windows Firewall with Advanced Security Getting Started Guide &#8211; <\/em><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/cc748991(WS.10).aspx\"><em>https:\/\/technet.microsoft.com\/en-us\/library\/cc748991(WS.10).aspx<\/em><\/a><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Firewall rules can also be configured as part of domain policies and hence please work with your domain policies to check if there are any such rules that can block the connection.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-other-firewall-products\">2. Other Firewall products<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-proxy-and-routers-and-other-components-in-your-network-proxies-can-act-as-firewall-as-well-and-hence-please-work-with-your-network-admin-to-make-sure-port-1433-is-open-for-outbound-access\">3. Proxy and Routers and other components in your network: Proxies can act as firewall as well and hence please work with your network admin to make sure port 1433 is open for outbound access.<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Note that both software (including windows firewall) and hardware must be checked.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please confirm the external IP address as this may be required to apply the correct firewall rule. You may use this website to find your IP Address<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The AddFirewallRule dialog box under SQL Azure Firewall Setting Tab in the portal will also list your IP address.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-if-possible-try-connecting-to-sql-azure-from-a-machine-outside-your-firewall-that-is-directly-connected-to-your-isp\">4. If possible try connecting to SQL Azure from a machine outside your firewall that is directly connected to your ISP.<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Please repeat all the steps under Section 1. This test would eliminate firewall and other policies that could potentially be blocking the access inside your network. This test will help identify if the traffic is being blocked within your network or outside your network.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-generate-a-network-trace-using-microsoft-network-monitor-tool\">5. Generate a Network Trace using Microsoft Network Monitor tool<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><em>Reference: How to capture network traffic with Network Monitor &#8211; <\/em><a href=\"https:\/\/support.microsoft.com\/kb\/148942\"><em>https:\/\/support.microsoft.com\/kb\/148942<\/em><\/a><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Review the trace by adding a filter TCP.port==1433 which would show conversations on TCP port 1433. If you do not see an ACK back from the server, it is highly likely that the connection is blocked on your network or over the internet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A network snippet from a connection that was not successful:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:27.007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:7, IPv4:6}&nbsp;&nbsp; 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;&#8230;S., SrcPort=49411, DstPort=1433, PayloadLen=0, Seq=2375502765, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:30.007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:7, IPv4:6}&nbsp;&nbsp; 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[<b>SynReTransmit #25<\/b>]Flags=&#8230;&#8230;S., SrcPort=49411, DstPort=1433, PayloadLen=0, Seq=2375502765, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:36.007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:7, IPv4:6}&nbsp;&nbsp; 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[<b>SynReTransmit #25<\/b>]Flags=&#8230;&#8230;S., SrcPort=49411, DstPort=1433, PayloadLen=0, Seq=2375502765, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:48.014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:12, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;&#8230;S., SrcPort=49412, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=3206081271, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:49.015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:13, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;&#8230;S., SrcPort=49413, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=1361088072, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:49.019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ICMP&nbsp;&nbsp;&nbsp;&nbsp; ICMP:Echo Request Message, From 111.11.11.111 To 65.55.74.144<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:50.769&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ICMP&nbsp;&nbsp;&nbsp;&nbsp; ICMP:Echo Request Message, From 111.11.11.111 To 65.55.74.144<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:51.014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 46&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:12, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #40]Flags=&#8230;&#8230;S., SrcPort=49412, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=3206081271, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:52.015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:13, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #41]Flags=&#8230;&#8230;S., SrcPort=49413, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=1361088072, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:52.771&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:14, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;&#8230;S., SrcPort=49414, DstPort=NETBIOS Session Service(139), PayloadLen=0, Seq=265110652, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:55.771&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 49&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:14, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #48]Flags=&#8230;&#8230;S., SrcPort=49414, DstPort=NETBIOS Session Service(139), PayloadLen=0, Seq=265110652, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:57.021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:12, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #40]Flags=&#8230;&#8230;S., SrcPort=49412, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=3206081271, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:12:58.016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:13, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #41]Flags=&#8230;&#8230;S., SrcPort=49413, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=1361088072, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11:13:01.771&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:14, IPv4:6} 111.11.11.111&nbsp;&nbsp;&nbsp; data.sn1-1.database.windows.net&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:[SynReTransmit #48]Flags=&#8230;&#8230;S., SrcPort=49414, DstPort=NETBIOS Session Service(139), PayloadLen=0, Seq=265110652, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here we can see that the client is trying to establish a connection to SQL Azure and keeps retransmitting three times and fails. This trace indicates that the connection did not even reach our VIP and hence the connection is likely blocked in the client\u2019s network or over the Internet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Snippet of trace from a successful connection:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14:50:01.512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 847&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLCMD.EXE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:428, IPv4:427}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99.99.999.99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 157.54.118.18&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;&#8230;S., SrcPort=13415, DstPort=1433, PayloadLen=0, Seq=4009972475, Ack=0, Win=8192 ( Negotiating scale factor 0x2 ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14:50:01.515&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 848&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLCMD.EXE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:428, IPv4:427}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 157.54.118.18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99.99.999.99&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;A..S., SrcPort=1433, DstPort=13415, PayloadLen=0, Seq=2117383693, Ack=4009972476, Win=8192 ( Scale factor not supported ) = 8192<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14:50:01.516&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 849&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLCMD.EXE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {TCP:428, IPv4:427}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99.99.999.99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 157.54.118.18&nbsp;&nbsp;&nbsp; TCP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP:Flags=&#8230;A&#8230;., SrcPort=13415, DstPort=1433, PayloadLen=0, Seq=4009972476, Ack=2117383694, Win=17040 (scale factor 0x0) = 17040<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The above snippet represents a successful three-way handshake.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-sql-azure-denial-of-service-dos-guard\">6. <b>SQL Azure Denial of Service (DOS) Guard<\/b>:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Azure utilizes techniques to prevent denial of service attacks. If your connection is getting reset by our service due to a potential DOS attack you would be able to see a three way handshake established and then a RESET in your network trace.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"section-4-accessing-resources\">Section 4: Accessing Resources<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Provide complete output (Screenshot) from the following SQLCMD :<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">SQLCMD -S bd1mgcqz5f.database.windows.net -U &lt;userid&gt;@bd1mgcqz5f -P &lt;password&gt; -q &#8220;select 1&#8221;<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">2. Connect using SSMS<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please use SQL Server 2008 R2 to connect to SQL Azure since it has lot of features enabled for SQL Azure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[This article was contributed by the SQL Azure team.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[48],"audience":[],"content-type":[1511],"product":[1539],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-7276","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","tag-big-data","content-type-best-practices","product-azure-sql-database","review-flag-1680286581-295","review-flag-1-1680286581-825","review-flag-2-1680286581-601","review-flag-3-1680286581-173","review-flag-4-1680286581-250","review-flag-5-1680286581-950","review-flag-6-1680286581-909","review-flag-7-1680286581-146","review-flag-8-1680286581-263","review-flag-never-1680286580-606"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2010-03-22T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-11T16:39:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"SQL Azure Connectivity Troubleshooting Guide\",\"datePublished\":\"2010-03-22T00:00:00+00:00\",\"dateModified\":\"2025-09-11T16:39:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\"},\"wordCount\":2861,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\",\"keywords\":[\"Big Data\"],\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\",\"name\":\"SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\",\"datePublished\":\"2010-03-22T00:00:00+00:00\",\"dateModified\":\"2025-09-11T16:39:43+00:00\",\"description\":\"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Azure Connectivity Troubleshooting Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog","description":"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/","og_locale":"en_US","og_type":"article","og_title":"SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog","og_description":"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2010-03-22T00:00:00+00:00","article_modified_time":"2025-09-11T16:39:43+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"SQL Azure Connectivity Troubleshooting Guide","datePublished":"2010-03-22T00:00:00+00:00","dateModified":"2025-09-11T16:39:43+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/"},"wordCount":2861,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp","keywords":["Big Data"],"articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/","name":"SQL Azure Connectivity Troubleshooting Guide | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp","datePublished":"2010-03-22T00:00:00+00:00","dateModified":"2025-09-11T16:39:43+00:00","description":"This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error\u2026","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/03\/clip_image002_thumb.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/sql-azure-connectivity-troubleshooting-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"SQL Azure Connectivity Troubleshooting Guide"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=7276"}],"version-history":[{"count":2,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7276\/revisions"}],"predecessor-version":[{"id":46089,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7276\/revisions\/46089"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=7276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=7276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=7276"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=7276"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=7276"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=7276"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=7276"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=7276"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=7276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}