Troubleshooting: Azure Storage Emulator failing to Install

Posted by Nilay Parikh and last modified on Tue Jun 12, 2018.

Windows Azure Storage Emulator failing with error – Sql instance not found.

Error Description

CAQuietExec:  Windows Azure Storage Emulator 3.0.0.0 command line tool
CAQuietExec:  Error: No available SQL Instance was found.
CAQuietExec:  Error 0xfffffff6: Command line returned an error.
CAQuietExec:  Error 0xfffffff6: CAQuietExec Failed
CustomAction RunInitialize returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

There is a potential issue with sqllocaldb during the install, and a potential workaround would be to recreate it. The following command will delete problematic files, Warning: before running any command make sure that you are not using or storing any historical data at the location. The data will be lost.

sqllocaldb stop v11.0
sqllocaldb delete v11.0
del %UserProfile%\WAStorageEmulatorDb30*.*
sqllocaldb create v11.0

Note: Windows 8 should be username - or you can always hardcode your profile directory.

Advance troubleshooting

  1. Uninstall previous versions of Azure SDK.
  2. Run following – verify the correct instance.

    sqllocaldb info
    
  3. Delete WAStorageEmulatorDb files manually from the correct instance.

  4. Run following commands.

    sqllocaldb stop v11.0
    sqllocaldb delete v11.0
    sqllocaldb create v11.0
    
  5. sqllocaldb info – verify the instance

  6. Re-install Azure SDK 2.5 via Web Platform Installer

  7. Run following

    c:\Program Files (x86)\Microsoft SDKs\Azure\Storage Emulator\WAStorageEmulator.exe init
    c:\Program Files (x86)\Microsoft SDKs\Azure\Storage Emulator\WAStorageEmulator.exe start
    
  8. Verify {username}\WAStorageEmulatorDb34.* files.

Hope you have running Azure Storage Emulator.

Disclaimer

Any views or opinions expressed are solely those of the author and do not represent any other person or organisation. THE ARTICLE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND. IN NO EVENT SHALL THE AUTHOR(S) OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY.