SQL Azure Management Portal returns error as An exception occurred while executing the Transact-SQL statement

While creating a new Table in SQL Azure using SQL Azure Management Portal, you might see the following error: While collecting this error details you will see the following crucial information: An error was encountered while applying the changes. An exception occurred while executing the Transact-SQL statement: DECLARE @PageSize float SET @PageSize= 8.0; use [master]…


Windows Azure Application launch failed with an error "This access control list is not in canonical form and therefore cannot be modified"

Environment: Visual Studio 2010 Professional SP1 & Windows Azure SDK 1.5   While working on an issue, I found an interesting issue with a new hello worlds ASP.NET based web role. When launching this application with or without debugger, the exception was generated as below:   System.ServiceModel.FaultException`1 was unhandled Message=This access control list is not…

5

Total Number of Endpoints (Input and Internal) in Windows Azure Role

In Windows Azure your service communicate form its endpoints and the endpoints are two type: Input (External) Internal Your role  must have at least one endpoint in it. You can not have role without any endpoint. Service Specific Limit: For any service you can have maximum 25 input (external) endpoints. The total limit for any…

1

Opening an internal http endpoint with WCF ServiceHost/BasicHttpBindings may cause System.Net.HttpListenerException/System.ServiceModel.AddressAccessDeniedException

When using WCF endpoint in Windows Azure it is possible you may receive the following exception:   (bc8.9a0): CLR exception – code e0434352 (first chance) CLR exception type: System.Net.HttpListenerException     “Access is denied” (bc8.9a0): CLR exception – code e0434352 (first chance) CLR exception type: System.ServiceModel.AddressAccessDeniedException     “HTTP could not register URL http://+:20001/WCFEp/. Your process does…


System.UnauthorizedAccessException with ASP.NET Web Role in Windows Azure

After working in one Windows Azure issue in which the ASP.NET Web Role was stuck in between “Busy” and “Starting”, I decided to write the details to save some time for someone. After I logged in to Windows Azure VM and looked for Application Event logs I found the following two errors:   Error #1:…


Microsoft.WindowsAzure.StorageClient.CloudDriveException was unhandled by user code Message=ERROR_UNSUPPORTED_OS

I had my Windows Azure SDK 1.2 based ASP.NET application which was working fine in which I use a cloud drive within the Web role. I decided to upgrade the exact same application using Windows Azure SDK 1.3 and while testing it on cloud, immediately I hit the following error: Microsoft.WindowsAzure.StorageClient.CloudDriveException was unhandled by user…