eulerfx's questions

I'm considering using a DNS solution to solve the issue with elastic IPs for Windows Azure roles. This blog post describes how to have both example.com and www.example.com point to an azure role such as example.cloudapp.net. However, I would like to streamline the process so that there is no forwarding.

One solution I've found is DNS Azure and another that seems to fulfill the requirements is Amazon Route 53. I was wondering whether anyone has had experience with either one of those for this particular task.

I am running SQL Server 2008 Express Edition on Windows Server 2008 with an ASP.NET application which must access the server. The ASP.NET application is associated with an application pool that runs on the NetworkService account. This account in turn has a Login and User record on SQL Server in the required database. When I attempt to run the ASP.NET website I get a blank page and when viewed in the error log, I seem to be getting this information event record:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: myLocalMachine]

The connection string has Trusted_Connection=True; and the required database specified.

When I explicitly specify the user name and password I get another login error stating the password is incorrect, even though the same un/pw combination works through SQL Server Management studio. The NETWORK SERVICE account seems to have all the required privileges for the database. Also, I made a test ASP.NET website project which does a simple select from a table in that database, and using the same config file I am not getting the error and it seems to work.

Is it something to do with trust levels then, because the original ASP.NET web app references various DLLs including open source libraries. Also, the application does not seem to be able to write to the event log itself, throwing a security exception, even though everything in the config files, including machine.config states the app is in full trust.