Windows Azure Storage Emulator failed to install

37
votes

I almost wasted my whole day trying to install Windows Azure Storage Emulator but somehow it is not getting installed..

The log is showing me this error : Sql instance not found. I tried re-installing Sql server 2012 but it did not help. It is not able to find Sql instance at all..

Here is the detailed log : http://pastebin.com/KUW4mjuf

I tried googling around but ended up with no solution at all.

:-( I can't go ahead without Azure Storage emulator..

I hope somebody here will help.

6
azureazure-storage

6 Answers

59
votes

There may be an issue with the sqllocaldb user database v11.0 during the install. You need to recreate it (see below).

As far as I'm concerned, my first install attemp left some files in my c:\users[user] directory :

  • WAStorageEmulatorDb30.mdf
  • WAStorageEmulatorDb30_log.ldf

(Your version numbers may differ.) The sqllocaldb logs would mention these files still existed and it would not erase them.

I just deleted them manually. Recreated the v11.0:

  • sqllocaldb stop v11.0
  • sqllocaldb delete v11.0
  • sqllocaldb create v11.0

And reinstalled.

7
votes

For those who has new Azure Storage Emulator 4.5 and SQL Server 2016. As MWood mentioned, check c:\users[UserProfile] directory and delete any AzureStorage* databases found.

Then open command window and write same commands, but change database to V13 (the number depends on the SQL server database version installed on your machine).

sqllocaldb stop v13.0
sqllocaldb delete v13.0
sqllocaldb create v13.0

enter image description here

Then install Azure SDK tools again.

5
votes

I had this problem too. But I solved it with it:

  • Programs and Features
  • Selected Visual Studio 2015
  • Selected "Change -> Modify"
  • Checked "Microsoft SQL Server Data Tool" and Click "Install"
1
votes

This didn't work for me. I'm using Parallels on OSX and have an automatic "network profile" with a long path name for my desktop and download folders. Parallels does this automatically

Another solution that worked for me:

  • Manually download the MSI referenced in the error log

  • Create a new LOCAL username (not passport/LiveID connected)

  • Install the MSI from C:\ NOT downloads (where Parallels is backing it as a UNC)

I think it's hitting a 255 char limitation in Windows UNCs'

0
votes

To keep my laptop responsive during startup, I have changed the sqlserver (express) service startup to manual during its installation. Emulator failed without any error that sql server is not running. On seeing this question, I realized to start the sql server service and then, the installation (emulator 3.2) wen through.

0
votes

I was able to resolve this problem for myself by running:

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" create MSSQLLocalDB

Simple but effective.