Command line start ssms with localdb does not work

Question

I have a requirement to start ssms (SQL Management Studio) from the command line that connects to a (localdb)\myinstance. The instance exists

sqllocaldb info myinstance

but using the command line and the -S parameter with (localdb)\myinstance throws an error.

PS C:\workingArea> ssms -S(localdb)\myinstance
localdb : The term 'localdb' is not recognized as the name of a cmdlet, function, script file, or operable program.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:9
+ ssms -S(localdb)\myinstance

I can connect using the named pipe but would ideally like to use the known name.

Do you have to share the instance? The only other thing I have found is something about (localdb)\. — Luke Duddridge

Cpt. Monac Cpt. Monac · Accepted Answer · 2015-12-05T01:00:59

1

votes

You can try the following: ssms -S LOCALHOST\myinstanceto connect to a LocalDb instance

Command line start ssms with localdb does not work

1 Answers