Issue Connecting to SQL Azure RRS feed

  • Question

  • Is anyone having problems connecting to Azure?
    Havent been able to connect for the past few days...
    Anyone else experiencing this?

    Named Pipes Provider: Could not open a connection to SQL Server [53].
    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
    stance-specific error has occurred while establishing a connection to SQL Server
    . Server is not found or not accessible. Check if instance name is correct and i
    f SQL Server is configured to allow remote connections. For more information see
     SQL Server Books Online..
    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
    Monday, November 2, 2009 6:24 PM


All replies

  • A firewall feature has been added to Sql Azure. Go to your Dev Portal and look at your databases. If the option ... 'Allow Microsoft Services to connect' (or something like that) is not checked, please check it and try again.
    Monday, November 2, 2009 6:37 PM
  • Hi,
    Have you checked the "Allow Microsoft Services Access to this server"
    And Have you added the range of ip address?

    Tuesday, November 3, 2009 6:03 AM
  • Yes, It was the firewall issue.

    Thanks a stack.


    Monday, November 9, 2009 6:46 AM
  • Just note to this firewall settings.  If you try it immediately it may not work some times it takes about 5 minutes enable access to those changes.
    Monday, November 9, 2009 6:55 PM