none
Database is not responding

    Question

  • Hi all!

    Whole morning I cannot connect to SQL azure database neither from application nor by Management Studio

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to wf9158ar5z.database.windows.net.

    ------------------------------
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

    Monday, February 28, 2011 9:15 AM

Answers

All replies

  • Hi Michael

    I cannot confirm this, here I have access in Europe West. Which region are you in?

    Monday, February 28, 2011 9:24 AM
  • Hi Marc!

    I'm from Ukraine, trying to access Western Europe

    Firewall check passed

    Here is trace:

      4    22 ms    21 ms    21 ms  telemost-tr.ua-kiev.datagroup.ua [80.91.170.157]

      5    59 ms    59 ms    64 ms  ams-ix-1.microsoft.com [195.69.145.20]
      6     *        *        *     Request timed out.
      7     *        *        *     Request timed out.

    Network monitor:

    130    11:32:18 AM 28-Feb-11    9.9578736    Ssms.exe    10.38.12.58    data.am2-1.database.windows.net    TCP    TCP:Flags=......S., SrcPort=52786, DstPort=1433, PayloadLen=0, Seq=610913458, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192    {TCP:54, IPv4:53}
    172    11:32:21 AM 28-Feb-11    12.9571608    Ssms.exe    10.38.12.58    data.am2-1.database.windows.net    TCP    TCP:[SynReTransmit #130]Flags=......S., SrcPort=52786, DstPort=1433, PayloadLen=0, Seq=610913458, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192    {TCP:54, IPv4:53}
    230    11:32:27 AM 28-Feb-11    18.9633938    Ssms.exe    10.38.12.58    data.am2-1.database.windows.net    TCP    TCP:[SynReTransmit #130]Flags=......S., SrcPort=52786, DstPort=1433, PayloadLen=0, Seq=610913458, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192    {TCP:54, IPv4:53}

    Monday, February 28, 2011 9:35 AM
  • Hi Michael

    from which SQL Server Management Studio version are you trying to connect? As far as I know it only works with SQL Server 2008 R2.

     

    Monday, February 28, 2011 9:42 AM
  • from which SQL Server Management Studio version are you trying to connect? As far as I know it only works with SQL Server 2008 R2.

    Yes, it is.

    Everything was Ok last Friday, and I'm 99 percent sure that this is not a problem on my side.

     

    UPD

    Strange, at the same time can connect to database using Silverlight Database Manager

    Monday, February 28, 2011 9:47 AM
  • Hi Michael

    here you have a link for the status of the cloud, but Database services seem to run all normally

    http://www.microsoft.com/windowsazure/support/status/servicedashboard.aspx

    I suggest you open a ticket with Azure Support:

    http://www.microsoft.com/windowsazure/support/

    Monday, February 28, 2011 9:53 AM
  • Forgot to mention, Currently all supports are free of charge. Please check this resource:

    http://blogs.msdn.com/b/windows-azure-support/archive/2011/02/25/please-post-questions-on-the-forums.aspx

     

    Monday, February 28, 2011 9:59 AM
  • Hi Marc!

    Thank you. I'll try with support ticket.

    Monday, February 28, 2011 10:17 AM
  • There is a TechNet wiki article on troubleshooting SQL Azure connectivity issues:

    SQL Azure Connectivity Troubleshooting Guide

    http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-connectivity-troubleshooting-guide.aspx

    This TechNet wiki article takes about general connection management in SQL Azure:

    SQL Azure: Connection Management in SQL Azure

    http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-connection-management-in-sql-azure.aspx

     

    Monday, February 28, 2011 3:37 PM
  • It appeared to be a problem with firewall of our provider.  :-(
    Monday, February 28, 2011 3:57 PM
  • Hi Michael

    Good you solved this issue - thanks for reporting back.

    Monday, February 28, 2011 4:02 PM