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
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:
|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