Can no longer connect to localdb after updating from Sql Server 2016 to 2019
0
votes
2
answers
5083
views
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 downloaded 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.
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:
-none
PS C:\Program Files\Microsoft SQL Server\150\Tools\Binn> SqlLocalDb.exe i
MSSQLLocalDB
PS C:\Program Files\Microsoft SQL Server\150\Tools\Binn> SqlLocalDb.exe s "MSSQLLocalDB"
Start of LocalDB instance "MSSQLLocalDB" 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
Asked by FDM
(101 rep)
Feb 28, 2021, 08:13 PM
Last activity: Oct 12, 2021, 04:04 AM
Last activity: Oct 12, 2021, 04:04 AM