To perform some testing, I ran the following:
USE mydb; GO EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE ; GO EXEC sp_configure 'user connections', 1; GO RECONFIGURE; GO
Then I restarted the computer.
Then I am unable to connect to the SQL Express Server.
Then I installed SQL Developer Server. Changing port numbers is a small price to pay for being able to continue working.
While I can now use the server, I am unable to do any development because when my application tries to connect, it gets "Error reading prelogin response: Connection reset".
So, I try to open SQL Server 2019 Configuration Manager, and it gives the error prompt "Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]"
And when I try to uninstall, repair, or whatever, I get "Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_ Slp: Value cannot be null."
How to resolve? If it's too screwed, then how to manually remove everything so that I can install a fresh copy?