Saturday, November 15, 2008

Azure Tip: How to Get Cloud Storage Working Locally if You're Not Running SQL Server Express

by David Pallmann via Fire & Ice: David Pallmann's Web & Cloud Blog on 11/15/2008 2:31:00 PM

If you're having trouble getting cloud storage to run locally on your box, this tip from Neudesic rock star Chris Rolon may help. It's especially likely this is your problem if the version of SQL Server you run isn't SQL Server Express.

If you're not running SQL Server Express, you'll need to change two values in the DevelopmentStorage.exe.config file which resides in C:\Program Files\Windows Azure SDK\v1.0\bin to have the correct SQL Server instance name (shown in red below).

• The first is the DevelopmentStorageDbConnectionString value in the connectionStrings section.
• The second is the dbServer value in the developmentStorageConfig section's third Service entry (the one named Table).

<connectionStrings>
<add name="DevelopmentStorageDbConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DevelopmentStorageDb;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
<add key="ClientSettingsProvider.ServiceUri" value="" />
</appSettings>