SQL Azure OData Service can be accessed from both HTTP or HTTPS application.
Can you please post the errors you are getting while accessing the SQL Azure OData service ?
Please verify the following
1. Check whether "Allow Microsoft Services" is enabled in SQL Azure Firewall
2. Test SQL Azure ODATA service from odata explorer such as http://metasapiens.com/sesame/data-browser/preview/ or http://www.silverlight.net/content/samples/odataexplorer/,
Both of these 2 ODATA Explorer websites are running in HTTP and accessing SQL Azure OData service running on HTTPS
I have the firewall configured properly because I can access the data from our office. Moreover, I can access the odata service from the browser by typing the URL that I was given when enabled the ODATA service for Azure SQL - https://odata.sqlazurelabs.com/OData.svc/v0.1/mySQLServer/myDatabase/
However, when I try to access this resource from a java script on a web site running on different domain I am not getting
data back although, the call goes out and the odata.sqlazurelabs.com responds
with some data but I cannot inspect it because it is encrypted.
So my first question is how I access the odata.sqlazurelabs.com/OData.svc over
HTTP connection since in the configuration portal https://www.sqlazurelabs.com/ConfigOData.aspx I am presented with the https link only.