Keeping PCs Safe on the Internet

PC Security Journal

Subscribe to PC Security Journal: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get PC Security Journal: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


PC Security Journal Authors: RealWire News Distribution, Denise Dubie, Lacey Thoms, Bob Gourley, Michael Bushong

Related Topics: Data Services Journal, PC Security Journal, Azure Cloud on Ulitzer, Security Journal, Microsoft Developer, CIO/CTO Update

Blog Feed Post

Troubleshooting SQL Azure Connectivity

Helping you to understand some of the common connectivity error messages

Awesome post on how to troubleshoot SQL Azure connectivity by SQL Services Team, helping you to understand some of the common connectivity error messages that you would see while connecting to SQL Azure as listed below:

  • A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
  • System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
  • 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
  • Error: Microsoft SQL Native Client: Unable to complete login process due to delay in opening server connection.
  • 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.

Some troubleshooting tips

Verify Azure Firewall Settings and Service Availability
Reference: SQL Azure Firewall - http://msdn.microsoft.com/en-us/library/ee621782.aspx

Verify that you can reach our Virtual IP
Reference: Telnet Troubleshooting Guide - http://technet.microsoft.com/en-us/library/cc753360(WS.10).aspx

Reference: How to Use TRACERT to Troubleshoot TCP/IP Problems in Windows - http://support.microsoft.com/kb/314868

Windows Firewall on the local machine
Frequently Asked Questions - http://msdn.microsoft.com/en-us/library/bb736261(VS.85).aspx

Reference: Windows Firewall with Advanced Security Getting Started Guide - http://technet.microsoft.com/en-us/library/cc748991(WS.10).aspx

Other Firewall products

Reference: http://www.whatismyip.com/

Generate a Network Trace using Microsoft Network Monitor tool

Reference: How to capture network traffic with Network Monitor - http://support.microsoft.com/kb/148942

SQL Azure Denial of Service (DOS) Guard

See SQL Data Services Team Blog for the full post on this issue.

Read the original blog entry...

More Stories By Alin Irimie

Alin Irimie is a software engineer - architect, designer, and developer with over 10 years experience in various languages and technologies. Currently he is Messaging Security Manager at Sunbelt Software, a security company. He is also the CTO of RADSense Software, a software consulting company. He has expertise in Microsoft technologies such as .NET Framework, ASP.NET, AJAX, SQL Server, C#, C++, Ruby On Rails, Cloud computing (Amazon and Windows Azure),and he also blogs about cloud technologies here.