Can no longer connect to localdb after updating from Sql Server 2016 to 2019 I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I download and installed SQL Server Express 2019 and uninstalled the older version.
However, SMSS can't connect anymore to (localdb)\MSSQLLocalDB.
I read somewhere to add a firewall rule for sqlservr.exe. When I try to run that file manually, it says the SQL Server installation is corrupt.
So I ran the Repair from SQL Server Installation Center, everything was okay in the output log but still no luck.
I'm pretty clueless, any help is appreciated.
Edit - the available services:




Status
Name
DisplayName




Running
MSSQL$SQLEXPRESS
SQL Server (SQLEXPRESS)


Stopped
SQLAgent$SQLEXP...
SQL Server Agent (SQLEXPRESS)


Stopped
SQLBrowser
SQL Server Browser


Running
SQLTELEMETRY$SQ...
SQL Server CEIP service (SQLEXPRESS)


Running
SQLWriter
SQL Server VSS Writer




The list of LocalDb instances:
MSSQLLocalDB

PS C:\Program Files\Microsoft SQL Server\150\Tools\Binn&gt; SqlLocalDb.exe s &quot;MSSQLLocalDB&quot;
Start of LocalDB instance &quot;MSSQLLocalDB&quot; failed because of the following error:
Cannot create an automatic instance. See the Windows Application event log for error details.

Event viewer details:
LocalDB parent instance version is invalid: MSSQL13E.LOCALDB
check the
SQL Server Configuration Manager see manual

On the right side you see which server are running and how to call them in the brackets.
and see if it is called MSSQLLocalDB any longer