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

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

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.
8,453 questions
{count} votes

Accepted answer
  1. answered 2021-11-11T06:59:14.8+00:00
    Seeya Xi-MSFT 12,376 Reputation points Microsoft Employee

    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
  1. answered 2021-11-09T09:24:05.567+00:00
    Seeya Xi-MSFT 12,376 Reputation points Microsoft Employee

    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.