Cannot connect to SQL Azure using SQL Server Management Studio

4
votes

I have create a SQL Azure database on the Azure portal, now I want to connect to it using SQL Server Management Studio. I've set my properties like this:

Server Type:Database Engine:
Server Name:[mycred].database.windows.net
Authentification: SQL Server Authentification
username: myusername
password: mypassword

But when I try to connecting with these properties I get an error:

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)

Whereas I have configure firewall on my SQL Azure database. How to solve this issue?

1
sql-server-2008azure-sql-database
which version of SSMS are you using? See this question – Jason
Are you sure you're still appearing to Azure as the same IP address you've configured the firewall for? This can change if your DHCP lease has been renewed by your provider, the service has gone down, you've rebooted your cable modem or router, you've connected to a VPN, etc. etc. – Aaron Bertrand
i'm using Microsoft SQL Server Management Studio version 10.0.1600.22, – troya_adromeda
My ip address still same which i configure on firewall, I have configure my local firewall which allow inbound and outbound port 1433 Any other suggesstions ? – troya_adromeda

1 Answers

3
votes

Your request has not left your machine that's why it is returning network error. There could be several issues and first start with SQL Server Management Studio. You must have SSMS R2 2008. Any non R2 version will not work.

Here is a list of test you would need to perform to troubleshoot the problem and apply solution:

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