sql azure connection

Question

I am using the azure platform for testing purposes.
I use SSMS (2008)
I usually connect from my office (adsl, router), but when I try to connect from my home (cable modem, router) I get a error message.
I use the same notebook on both places.
I open the firewall ip's on both places.
I get the message
     'sqlcmd: error: Microsoft SQL Server Native Client 10.0 : A network-related-stance specific error has occurred ....
      Login timeout expired. (microsoft Sql Server error. Error 10060)'
I tried to bypass the router, but got the same result.
I tried to connect using SQLCMD, changing the command line, but got the same message.

Connection in SSMS  SERVER NAME xxxxxxxxxx.database.windows.net 
                               AUTHENTICATION Sql Server Authentication
                               LOGIN xxxxxxxxxx
                               PASSWORD xxxxxxxxxxxx
                               DATABASE master
                               NETWORKPROTOCOL TCP/IP

Connection in SQLCMD -S xxxxxxxxxx.database.windows.net -U xxxxxxxxx@xxxxxxxxxxx -P xxxxxxxxxxx -d master

Thanks

Jorge

Answer 1

Hello,
Just to eliminate obvious - did you double check your home IP address range for Firewall Rules in SQL Azure ?
Does your cable modem has some outbound filtering? Contact your ISP and ask them if they have filtered port 1433.
Maybe some ISPs have firewall rules and are blocking in/outbound connections to port 1433 because of the SQL slammer (if we go back to early 2003 we will remember that warm - http://en.wikipedia.org/wiki/SQL_slammer_(computer_worm) ). In my location for example it is very common for ISPs to block outbound port 25 for example - a spam prevention measure.

(P.S. I think this post should go to SQL Azure forum, not here).

Answer 2

Anton,

first of all thanks for your attention.

Yes I did open the firewall settings.

I checked the modem page (thru the IP address) and didn't find any configuration option.

It's a WebSTAR DPX2203 modem.

I will check with the ISP for any blocking.

Thanks again.

Answer 3

Hi,
Have you checked the "Allow Microsoft Services Access to this server"
And Have you added the range of ip address?

Phaneendra.

Answer 4

Hi,

Yes.

I connect from the office, I can't connect from home.

Jorge

Answer 5

Did you check with your ISP. This is the only thing I think of, since you are able to connect from office but not from home - there are some network issues at your home place, but not in SQL Azure.

Answer 6

Anton,

I did check with the ISP and they say that there is no port blocking.

I will try another approach via Remote Desktop.

Thanks.