How to configure Windows Azure Samples to use SQL Server 2005

If you are setting up Windows Azure SDK with SQL Server (or any other server instance that does not sit on localhost/SQLExpress), here's what you have to do to make it work:

1. Locate [AzureSamples]\MSBuild\Microsoft.Samples.ServiceHosting.targets and add /server:localhost after the /database:$(SamplesDBName) for the DevTableGenCommand in 2 places
2. Open %ProgramFiles%\Windows Azure SDK\v1.0\bin\DevelopmentStorage.exe.config and fix connection string. You may need to make this file writeable under Vista.
3. Update dbServer for the Table service in the same file.