Windows Azure Platform Developer Center >
Azure Forums
>
SQL Azure — Getting Started
>
Issue Connecting to SQL Azure
Issue Connecting to SQL Azure
- 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.
Answers
- 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.
Pita.O:
http://www.arizentax.com/
http://www.cgi.com- Proposed As Answer byEvan BasalikMSFT, ModeratorMonday, November 02, 2009 7:46 PM
- Marked As Answer byEvan BasalikMSFT, ModeratorSunday, November 08, 2009 10:01 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.
Pita.O:
http://www.arizentax.com/
http://www.cgi.com- Proposed As Answer byEvan BasalikMSFT, ModeratorMonday, November 02, 2009 7:46 PM
- Marked As Answer byEvan BasalikMSFT, ModeratorSunday, November 08, 2009 10:01 PM
- Hi,
Have you checked the "Allow Microsoft Services Access to this server"
And Have you added the range of ip address?
Phaneendra. Yes, It was the firewall issue.
Thanks a stack.
Dimi- 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.
