Wednesday, January 15, 2020

Cant open SQL Server Configuration manager

I have run into this error a couple times now.  I'm not sure what causes it.  When trying to open SQL Server Configuration manager you get the following message:


There is a support article that covers how to fix this.

https://support.microsoft.com/en-us/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se

This article only covers 2005 to 2012, but I can confirm it works with 2017.  You just need to use the correct path.

Basically you run the following command.

mofcomp .\sqlmgmproviderxpsp2up.mof


At this point you should be able to open SQL Server Configuration Manger. Yay!

No comments:

Post a Comment