Running SQL Server Configuration Manager without SQL Server installed
I like to have SQL Server Management Studio (SSMS) installed as part of my standard development environment. Usually this is because I also have an instance of SQL Server Developer or Express Edition installed, but not always.
One thing I noticed with the separate distribution of SSMS is that it also includes all the other management tools that used to be bundled with the server, like SQL Server Configuration Manager.
I wanted to change the SQL Client configuration settings and Configuration Manager is the tool I’d use to do that. But when I fired it up (it’s named SQL Server vNext CTP2.0 Configuration Manager in the latest release of SSMS), I’ve been greeted with this message:
I don’t see this problem when an instance of SQL Server is installed though.
The fix is documented in KB 956013. I ran the following from an elevated command prompt:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\140\shared\sqlmgmproviderxpsp2up.mof"
Now SQL Server Configuration Manager starts up without error
Oh, and the easiest way to install SSMS is to use Chocolatey!
choco install sql-server-management-studio