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