Monday, February 1, 2021

Can't see SQL Server Configuration Manager in Computer Management

 So according to this doc on MS docs, I should be able to run configuration manager against a remote SQL server from a machine with a GUI.


https://docs.microsoft.com/en-us/sql/database-engine/install-windows/configure-sql-server-on-a-server-core-installation?view=sql-server-ver15


Except, as you can see from the screenshot, "SQL Server Configuration Manager" isn't anywhere in there.





The server is Windows Server Core 2019. MMC is a no-go.

So let's find the .msc, I thought, and so I pointed my File Explorer at c:\windows\system32. So I tried starting it manually, and got the error "Class not registered".



OK, this is Server Core, that's not really all that shocking.

I copied the .msc from my Server Core machine over to the GUI server I have SSMS installed on, and tried running it from there. This is the error I get.





So I'm going to have to figure out how to install the configuration manager without installing SQL Server itself.


No comments:

Post a Comment