09 March, 2024

Local database(localdb) not seen in SQL Server Explorer via Visual Studio

To establish a connection to a localdb in Visual Studio, such as "Server=(localdb)\mssqllocaldb; Database=IdentityDB," follow these steps:

  1. Go to Server Explorer > right-click on Data Connections > select Add Connection... 




  2. Manually input the server name as (localdb)\mssqllocaldb (with only one slash) > The newly created database with the name IdentityDB will be automatically populated. 



    Result: