We are in the process of migrating to Windows Azure, and we would like to connect our current servers to the Azure database to smooth the transition process.
I change the connection string to point to the Azure database, but as soon as I do that IIS will return a blank response (content-length 0, HTTP 200 OK). I have tried turning custom errors on, off, and also looking in the event log but there is nothing there. (edit: we are not deploying to Azure, merely pointing the database in web.config an Azure database.)
We can confirm the connection is working via another box, SQL Server Management Studio, and telnet on that machine.
It seems it's just this one project that's not working, I am able to get the other projects to point to the Azure database just fine.