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> 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
Best Answer
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