Failed to initialize Windows Azure storage emulator

Question

On my Windows 7 64bit system I have IIS 7,  and VS2010 Ultimate running with all of the Azure and .Net SDKs and toolkits. I can build the Default Coud Service ASP.Net Web Role Project with a serice to retreive data from an azure sql. I created a silverlight client that calls this WCF in the web role, but when I hit F5, I get the following Error:

Windows Azure Tools: Failed to initialize Windows Azure storage emulator. Unable to start Development Storage. Failed to start Development Storage: the SQL Server instance ‘localhost\SQLExpress’ could not be found. Please configure the SQL Server instance for Development Storage using the ‘DSInit’ utility in the Windows Azure SDK.

I noticed in the web.config the folowing

 

<add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"

providerName="System.Data.SqlClient" />

 

I changed it to connect to the same db but on my remote sql (I dont have sqlepresss on my dev machine), tried again but getting the same error

Answer 1

Please refer to my response to your other posting of this question. I'm 99% certain that you will need to have SQL Express installed locally. This is a free download: http://www.microsoft.com/express/Database/

Answer 2

I am facing a similar kind of issue but the error message reads as,

"Windows Azure Tools: Failed to initialize Windows Azure storage emulator. The type initializer for 'Microsoft.ServiceHosting.DevelopmentStorage.Utilities.DevelopmentStorageConfigCache' threw an exception. Object reference not set to an instance of an object."

This happened when i debugged the HomeController.cs file after inserting a trace statement as, "Trace.WriteLine(Request.Url.AbsolutePath);". Strange but i have already installed SqlExpress.

Answer 3

MariaTechie, i getting exactly this error message too.

Answer 4

Please keep in mind that thread is nearly 2 years old. :) If you do have SQL Express installed, it may be that the storage emulator was not able reach/create the necessary database. you can verify this by opening up SQL Management studio and looking for a database that is labelled starting "DevelopmentStorageDb<adatelikenumber>".

If that's not there, you can try using the DSINIT command to get development storage properly initiated. I recently had an issue with getting this to work properly and had to complete uninstall and re-install SQL Express before it was resolved.

Answer 5

You need to run DSInit utility to create database.

More information at http://myown.easytipsandtricks.com/windows-azure-error-failed-to-start-storage-emulator-the-sql-server-instance-localhost-sqlexpress-could-not-be-found.aspx

---

aditya