Unable to conect to Database(Checked Firewall and other config)

Question

Hello
I have the following problem:
I have a db called Ventas, but i cant to it with Management Studio and sqlcmd. Both said that they cant conect because time out.
i use the following sintax for sqlcmd: sqlcmd -S tcp:xxxxxxxx.database.windows.net -U gonzad26@xxxxxxx -P "xxxxxxxxxxx" -d Ventas
i put a firewall exception at my windows firewall, also i port forwared my router(1433 and 1434), algo i put a firewall rule at sql azure for my ip
In Management Studio i have done what all the people on internet says: to conect using a query not object explorer. but i cant conect

Please Help
Aditional Information if is needed: OS: Windows 7(English x86) and (English x64), Management Studio 2008, I'm in Argentina. I have a router a Linksys Wrt54g2.
PD: Even a app that i made to use this db cant conect.

Thanks and greetings from Argentina

Answer 1

Is this for the August CTP or the October CTP?  The URL for the August CTP is <servername>.ctp.database.windows.net (there is an extra 'ctp' in there).

Another common problem is a typo in the server name.  We generate them so that they are nice and secure but it also makes them non-intuitive and subject to typos.

Can you provide your server name so that we can see if there is any reported errors with it?

Thanks,

Patric

Answer 2

Is for the October CTP, and the url is: bqr4j1isgn.database.windows.net

Thanks for your atention
Gretings
Gonza

Answer 3

i put a firewall exception at my windows firewall, also i port forwared my router(1433 and 1434), algo i put a firewall rule at sql azure for my ip

I'm not a networking expert but I'm surprised that you need to forward ports 1433 and 1434. Typically, port forwarding is used when you are hiding a service behind NAT not when you are trying to go out from behind NAT as is likely the case here. Is it possible that you configured the firewall rule for your non-routable local IP (such as 192.x.x.x or whatever) instead of your, perhaps dynamic, public IP address? Furthermore, given that many ISPs use dynamic allocation of IP addresses are you certain that the address you configured is still your public IP address?

Answer 4

Gonza:

I can't see a 'Ventas' database associated with that server.  Checking the service, the server seems fine and I can ping the URL so it is registered with DNS ok.

Does the portal (https://sql.azure.com) report that this database exists in this server?  Can you provide a screen shot of the portal page?

Note: we only brought the account information over to the October CTP environment.  We'll roll anything in this environment into a real live (likely paid) subscription when we go live and we got a lot of feedback that people wanted to 'opt in' with their databases rather than having us bulk move everything in the earlier August CTP.  The data is all still there in the August CTP, of course.  But you will have to create the databases you want in the October CTP explicitly in this environment.  Otherwise, they won't exist yet.

Hope that helps.

Patric

Answer 5

Neil Thanks for your answer, but i port forwarded because i thought that is a network problem. 

Patric, i have created the Ventas database in the October CTP

This is a Screenshot of my azure page Also i try to ping bqr4j1isgn.database.windows.net but i cant

http://img43.imageshack.us/i/38677477.jpg/ <--- The Screenshot

Thanks

Answer 6

Cool.  Looks like the Ventas DB is created now in the October CTP.

What happens when you ping?  When I do it the DNS record seems to resolve to the right thing (our South Central data center) although the ping itself fails.

Now that the DB is created, are you still getting the time out when connecting via sqlcmd?

If you are still getting the timeout I'd normally suspect a network set up issue but it seems you're doing all the right stuff there - allowing outbound traffic on port 1433 and adding your client IP to the firewall settings for this SQL Azure server.

Patric

Answer 7

When i ping through cmd to bqr4j1isgn.database.windows.net. It says me time out. I dont know what is happening. Also i turn off the Windows Firewall, but i still cant.
This a screenshot of my firewall in azure
http://img27.imageshack.us/i/34685743.jpg/
I put 190.190.0.1 to 190.190.0.254 to prevent problems if my isp changes the ip. My ip now es 190.190.0.164. Also i tried with the range 190.190.0.164 to 190.190.0.164
but still dont work.

thanks

Answer 8

Are you still having trouble connecting?

If so, ping contact me privately at evanba at microsoft dot com.

Evan