SSMS Cannot connect to (localdb)\MSSQLLocalDB 2019

Question

Hello,

I'm trying to connect to the local instance (localdb)\MSSQLLocalDB with SSMS 19.02.

The connection attempt fails and I get :

"A network or instance-specific error occurred while trying to connect to SQL Server. The server cannot be found or is not accessible. Check that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. An error occurred when starting the local database instance: the SQL Server process could not start. ) (Microsoft SQL Server, Error: -1983577846) For help, click on: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--1983577846-database-engine-error"

I've already tried to reinstall, without success.

Does anyone have a solution?

Thank you for your help.

Answer 1

I found this:

2023-06-02 13:29:25.54 spid10s FCB::Open failed: Could not open file d:\dbs\sh\s19c\0719_152503\cmd\1e\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf for file number 0. OS error: 3(Le chemin d’accès spécifié est introuvable.).

and a few more of the same kind. Something has gone wrong during installation, so that master has the wrong path for model and msdb. I would try to uninstall and re-install.

Answer 2

I came into the same issue where error log gives 'OS error: 3(The system cannot find the path specified.).', and finally fixed by following https://stackoverflow.com/questions/34190872/sql-server-2014-localdb-stopped-working-after-reportviewer-2015-runtime-installa