SQL Azure Web Role runs through Dev Fabric but Server Error 500 in Cloud

Question

I have created a simple SQL Azure Web Role application that works from the fabric connecting to my SQL Azure using its FQDN (fully qualified domain name). It did require setting SQL Azure Server Firewall Settings with my host IP address.

 

However, the same SQL Azure Web Role application packaged is not running within the Cloud and it is returning:

Server Error 500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

 

1.      How can I diagnosis this problem to get it work in the Cloud?

2.      Do I need to add a SQL Azure Server Firewall Setting to get it to work in the Cloud?

 

---

Thanks
Jeff in Seattle

Answer 1

Hello Jeff,
You do need to add firewall rule in SQL Azure.
It is the checkbox "Allow Microsoft Services access to this server" which will add IP range "0.0.0.0 - 0.0.0.0".
Please check it and see if the error is still reproducible.
I guess you do not change the connection string when deploying on the cloud ?

Answer 2

Jeff,
I recall this happening to me. Most likely some of your .dlls are not copied in the deployment package. For my Silverlight app I had to add a couple of projects in Silverlight Applications tab in Web project properties. You will get the same error after you publish it to local IIS if those dlls are missing.

Hope it helps.
Vadim

Answer 3

Jeff,

Did you figure out what was missing here?

Evan