My (LocalDB)\v11.0 is not "running"

Question

In SqlServerManagementStudio (2012), (LocalDB)\v11.0 is not running in SSMS, I installed SqlExpress to use it from IIS.

What can I do to enable it?

Answer 1

In my case - localdb did work for me, but one day it "Stopped" - I was not able to connect to it not from IDE, and not from code.

I killed its process sqlservr.exe I found in Task Manager (actually, all processes - it were 2 of them).

This fixed the issue for me - was able to connect and work.

Answer 2

Instead of using (localdb)\v11.0, try to use (localdb)\mssqllocaldb as server name to connect to the LocalDB automatic instance. This solved the problem for me.