Sqllocaldb Info Lists Two Instances With The Same Name

When my IIS MVC4 Web App (running as my user) tries to connect to a named LocalDb Instance it fails to start MyInstance or connect to it. I have the auto-create section in my Web.c

Solution 1:

I never found an explanation for this, but the "ghost" instance, as I call it, comes from duplicate instances with that name owned by another user or artifacts of previous instances left in the Registry. If multiple instances show up in the list with the same name, you would have to manually log in as all users who have ever created LocalDb instances on your machine and stop and remove their instances. In some cases this is not enough. You also have to remove their Registry entries under the UserInstance section(s) of the Registry. It would be really nice to have a LocalDb management tool that can manage all users, but this does not exist. I have to use PsExec for service accounts.