Windows Azure Error: Failed to start Storage Emulator: the SQL Server instance ‘localhost\SQLExpress’ could not be found

When running some of your Windows Azure applications when storage emulator is not configured you may get the following error: "Windows Azure Tools: Failed to initialize Windows Azure storage emulator. Unable to start Development Storage. Failed to start Storage Emulator: the SQL Server instance ‘localhost\SQLExpress’ could not be found. Please configure the SQL Server instance for Storage Emulator using the ‘DSInit’ utility in the Windows Azure SDK.". Here’s how to solve this problem.

You need to run DSInit utility to create database. For Windows Azure SDK 1.6 the location for DSInit utility is:

C:\Program Files\Windows Azure Emulator\emulator\devstore

By default DSInit expects that your database server is (local)\SQLEXPRESS but you can change it easily. If you have MSSQL instance called SQLEXPRESS then it is enough to just run DSInit. If you need some other instance then run the following command:

DSInit /sqlinstance:<instance name>

For default instance use “.” as instance name:

DSInit /sqlinstance:.

You can find more information about sqlinstance and other switches from DSInit documentation. If database was correctly created you should see dialog like this:

Storage Emulator Initialization

When storage database is ready you can run your application.

Gunnar Peipman

Gunnar Peipman is ASP.NET, Azure and SharePoint fan, Estonian Microsoft user group leader, blogger, conference speaker, teacher, and tech maniac. Since 2008 he is Microsoft MVP specialized on ASP.NET.

    4 thoughts on “Windows Azure Error: Failed to start Storage Emulator: the SQL Server instance ‘localhost\SQLExpress’ could not be found

    • December 9, 2011 at 7:50 am
      Permalink

      Thank you. This worked great. For me, I was only able to get it to work with DSInit /sqlinstance:.

      That was a great tip! When I specified the actual instance name, it would fail. The period worked great.

    • March 19, 2012 at 12:51 pm
      Permalink

      Great – thanks for sharing. Like Tryoy only the default instance worked for me.

    • March 23, 2012 at 1:28 pm
      Permalink

      very usefulll….. thanks

    • May 9, 2012 at 10:06 am
      Permalink

      You are the best!!!

    Leave a Reply

    Your email address will not be published. Required fields are marked *