I am trying to connect to SqlAzure database from my windows azure account, when I try to authorize by giving valid database credentials I get the error as XMLHTTP Request does not exist.
I know that Azure is stateless. But the connections are maintained with state.Especially when we are trying to use asynchronous calls using the XMLHTTP request object it doesn't recognize .Hence we should not use XMLHttpRequest while working with Azure. But in this case I am not using any ajax calls or xmlhttprequests.
I thought might be internally azure is using xmlhttprequest. I also checked the IP addresses of my SQL Azure firewall to allow proxy IP. It is not dynamic, it’s not changed. If this is the case error will be different message. I also have all latest XML components installed in the box.
Can you guess what is the cause and problem?
The problem is its not getting connected in IE7 or FF3.6.
This silverlight application interface uses XMLHTTP requests from the client side, all the operations are made through a service on Azure using port 80, not directly to the SQL Azure server.since the Silverlight application uses local XMLHTTP requests components on your machine, we need to make sure that client machine using azure account has the latest XML components. Upgrading my browser to IE8 solved the issue, I think this updated latest updates and necessary components for XMLHttpRequest for Silverlight4. At least we need to have IE8/ IE9 to work. The cause is Silverlight 4.0 some problems with XMLHttpRequest in Firefox 3.6.
Sql Azure Tips
We should have sqlserver2008R2 to work with SqlAzure
SQL Azure is only compatible with SQL Server 2008 and SQL Server 2008 R2. If we are planning to migrate database to SQL Azure we should first upgrade it to run on SQL Server 2008 or SQL Server 2008 R2. We can take help of SQL Server 2008 Upgrade Advisor for compatibility test before migrating to SQL Azure.
The SQL Azure Migration Wizard is a very good tool for testing the compatibility between SQL Server 2008 and SQL Azure. This tooll can analyze SQL Profiler traces to check the compatibility of the T-SQL statements generated by the application.