How to connect to LocalDB in Visual Studio Server Explorer?

by

In Visual Studio 2012 all I had to do was enter:

(localdb)\v11.0

Visual Studio 2015 and Visual Studio 2017 changed to:

(localdb)\MSSQLLocalDB

as the server name when adding a Microsoft SQL Server Data source in:

View/Server Explorer/(Right click) Data Connections/Add Connection

and then the database names were populated. I didn’t need to do all the other steps in the accepted answer, although it would be nice if the server name was available automatically in the server name combo box.

You can also browse the LocalDB database names available on your machine using:

View/SQL Server Object Explorer.

More Related Contents:

  1. What are the various “Build action” settings in Visual Studio project properties and what do they do?
  2. Microsoft.ACE.OLEDB.12.0 provider is not registered
  3. What is “stdafx.h” used for in Visual Studio?
  4. Difference between Build Solution, Rebuild Solution, and Clean Solution in Visual Studio?
  5. Which winform project files should be packed up into the installer
  6. Visual Studio is acting weird. How do I fix this?
  7. How can I disable ReSharper in Visual Studio and enable it again?
  8. How to set standard encoding in Visual Studio
  9. How to make Visual Studio copy a DLL file to the output directory?
  10. Where is Developer Command Prompt for VS2013?
  11. “Process with an Id of #### is not running” in Visual Studio
  12. Displaying build times in Visual Studio?
  13. Compare two files in Visual Studio
  14. Visual Studio 2015 installer hangs during install?
  15. In Visual Studio, how can I set the Build Action for an entire folder?
  16. How do I change the startup project of a Visual Studio solution via CMake?
  17. Where can I get a VB6 IDE [duplicate]
  18. VS 2017 Installation failed
  19. Publish website without roslyn
  20. What does Visual Studio mean by normalize inconsistent line endings?
  21. Create a new TypeScript project in Visual Studio
  22. Visual Studio 2012 “Show All Files” button missing
  23. Where can I find the TypeScript version installed in Visual Studio?
  24. ‘nuget’ is not recognized but other nuget commands working
  25. Visual Studio isn’t tracking changes, or checking out files from source control as I edit them
  26. How to upgrade csproj files with VS2017
  27. Visual Studio open files question
  28. Recommended number of projects in Visual Studio Solution
  29. 500 Error Running Visual Studio ASP.NET Unit Test
  30. Structuring projects & dependencies of large winforms applications in C#

Leave a Comment