sql server - Visual Studio Code Map: Unable to connect to the specified database

Question

I can't use Code Map in Visual Studio due to this error:

Unable to connect to the specified database.

An exception occurred attempting to connect to a database using the following connection string: Data Source=(LocalDB)v11.0;AttachDbFilename=;Initial Catalog=master;Integrated Security=True;Enlist=False;Asynchronous Processing=True;MultipleActiveResultSets=True;Connect Timeout=30.

Check that the specified SQL Server instance exists and the service is running.

I've read this questions with the same problem:

Code Map not working in VS2012

visual studio 2012 ultimate new dependency graph error

1) I've installed SQL Server Data Tools for VS2012

2) I've updated VS, and re-installed SQL Server component (in a default uninstall/modify/repair menu)

3) Then I successfully stopped and deleted local database (like in 2nd question):

sqllocaldb stop "v11.0" -k

sqllocaldb delete "v11.0"

But failed to create one:

sqllocaldb create "v11.0"

Creation of LocalDB instance "v11.0" failed because of the following error:

The specified LocalDB version is not available on this computer.

But creating and starting another version succeeded:

sqllocaldb create "v12.0"

LocalDB instance "v12.0" created with version 12.0.2000.8.

sqllocaldb start "v12.0"

LocalDB instance "v12.0" started.

Now I'm confused what is actually wrong. After each step I restarted VS and tried to use diagrams - but nothing changed.

How to fix the problem?

Answer 1

This worked for me:

Delete, Create, Start localDB instance used by CodeMap:

%localappdata%MicrosoftMicrosoft SQL Server Local DBInstancesMSSQLLocalDB

Using these commands:

sqllocaldb stop "MSSQLLocalDB" -k
sqllocaldb delete "MSSQLLocalDB"
sqllocaldb create "MSSQLLocalDB" 
sqllocaldb start "MSSQLLocalDB"

Then restart VS