My Azure Web Application has no access to my SQL Azure DB

It seems that due to the SQL Azure Firewall Rules my Wi开发者_运维知识库ndows Azure has no access to the DB. Because of this I put one single rule that opens all:

MicrosoftServices IP-Start: 0.0.0.0 IP-End: 255.255.255.255

What now works is:

OK: When I run the Web-App locally inside VS2010 I have access to the remote SQL Azure DB.

NOT OK: But after deployment to Windows Azure there is NO access to the SQL Azure DB from inside the cloud!

---

In the Firewall Rules setup, did you check the box for "Allow other windows azure services access to this server"? If so, the firewall rules grid should have a row for "MicrosoftServices"

---

Thanks to everybody for all the time invested (and wasted, sorry). I don't believe it. It rememberes me my times with the Pascal compiler on a DEC PDP-11 in the early 80s, see my answer to @Eugenio.

Cause: the whole day I deployed the same old wrong *.cspkg from a subdirectory. From within which I NEVER accessed the SQL Azure Server!!

The same error on a local machine would have been resolved in 10 minutes by setting one breakpoint and F10ing through the code.