Cannot connect to SQL Azure using SQL Server Management Studio

Question

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?

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
– Aaron Bertrand, Commented May 31, 2012 at 4:22
i'm using Microsoft SQL Server Management Studio version 10.0.1600.22, — troya_adromeda
– troya_adromeda, Commented May 31, 2012 at 4:41
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
– troya_adromeda, Commented May 31, 2012 at 4:43

AvkashChauhan · Accepted Answer · 2012-05-31 05:42:35Z

3

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

answered May 31, 2012 at 5:42

AvkashChauhan

20.5k3 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

troya_adromeda Over a year ago

My my is SQL Server 2008 Management STudio, is it not R2 2008 too, in about page, it's show version 10.0.1600.22. is my mine right ?

AvkashChauhan Over a year ago

I dont remember the version but I am dead sure that only SSMS 2008 R2 connects with SQL Azure and you must have it to connect with SQL Azure.

troya_adromeda Over a year ago

OK, i get some strange when troubleshoot my connection problem.I can't "telnet <myserver>.database.windows.net 1433" console say that couldnot open connection to host. Where as i have allow 1433 port on my compute firewall, i have allowed this port on both of inbound and outbound connection, any suggesstions?

troya_adromeda Over a year ago

Hi AvkashChauhan, i'm sorry i don't know how useful of this.OK begin now i will give rate for answer which help me :)

troya_adromeda Over a year ago

Any idea how to make sure that i can access 1433 port, because on my firewall i have allow that port both of inbound and outhbound port.I'm also have tried to disable my firewall, but still same.I can't access it

|

Collectives™ on Stack Overflow

Cannot connect to SQL Azure using SQL Server Management Studio

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related