SQL Server: How to find all localdb instance names

Viewed 61400

I have two versions (2012, 2014) of SQL Server Express LocalDB installed in my system.

How can I find all existing LocalDB instance names?

I found a way to do that using command line as mentioned in the answers section.

Is there a better and easy way to do it?

5 Answers

In Visual Studio 2019 Server Explorer (or SQL Server Object Explorer button there) click "Add SQL Server" button

Add SQL Server Button

and expand the Local tab to view the list of local SQL Server currently running services it finds. Only when you connect to the selected server it will get listed in SQL Server Object Explorer:

SQL Server Object Explorer

Related