Quản lý LocalDB Visual studio 2012 - 2013 bằng SQL Server 2008/2005 - Manage SQL LocalDB by SQL Server

You can connect SSMS 2005/2008 to a LocalDB (2012) instance using named pipes.

1. Get the address of a (localdb) instance by running the following command:

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info [InstanceName]

//How:

Run -> cmd ->Enter

to open Command Promt

(if its the default instance you're interested in, specify v11.0 as the [InstanceName]

copy this text and paste in to cmd window: 

 "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info v11.0

*Keep the double quotes (" ") when you copying, they are necessary because our path have non standard path (eg: "MS Sql Server/abcs"). The quotes can be removed if the path is like D:\myDir\miMusic

2. Copy the value returned in the "Instance pipe name", e.g. np:\\.\pipe\LOCALDB#13E05E01\tsql\query.

It depend on each computer

3. Add a new server registration in SSMS and paste the "Instance pipe name" value as the Server Name.
NOTE: It is not necessary to specify "Named pipes" as the protocol. SSMS should detect the appropriate protocol for you.

How?

Simply, when you open SQL server, you meet the Authenticate dialog or Login dialog, paste the Namepipe text you have got in step 3 in the "server name" text box, User Name is "sa", Password is blank, no need for it.

Now enter, you can user your SSMS for LocalDBv11