can't connect to localdb 2019 from visual studio 2019 and 2017

G. Gunn - fs 146 Reputation points
2021-11-09T06:21:30.177+00:00

I installed sql server 2019 localdb via sql server 2019 setup, rebooted. went into visual studio 2019 installed data tools v15 with nuget for required projects. repeat for vs 2017 projects.
still can't connect to sql server 2019 localdb
147671-zlocaldb2.jpg

the features and app does show the targetloal db147539-zlocaldb.jpg

however, from command prompt 

C:\Users\g2>SqlLocalDB.exe start v15.0  
Start of LocalDB instance "v15.0" failed because of the following error:  
The specified LocalDB instance does not exist.  
  
C:\Users\g2>sqllocaldb info  
MSSQLLocalDB  
ProjectsV12  
ProjectsV13  
v11.0

what do I need to do?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
Accepted answer
  1. Seeya Xi-MSFT 16,436 Reputation points
    2021-11-11T06:59:14.8+00:00

    Hi @G. Gunn - fs ,

    You right-click here, then add a server, select the server you want and click connect.
    148491-1.png
    148308-2.png
    Hope your issue can be solved.

    Best regards,
    Seeya

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2021-11-09T09:24:05.567+00:00

    Hi @G. Gunn - fs ,

    Welcome to Microsoft Q&A!
    This seems to be without creating an instance. Have you ever created an instance of localdb 15?
    If not, run SqlLocalDB.exe create "instancename" 15.0 -s in cmd.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.