Problem Scenario:
I have upgraded the PC from Windows 8.1 Pro to Windows 10 Pro. But I do not see the SQL Server Configuration Manager program icon anymore, even by searching. I do see the four files in C:\Windows\System32 and C:\Windows\SysWOW64 (I have SQL Server 2008/2008R2, 2012, 2014, and 2016CP 2.2 on the same machine). When I click them, however, I see an error message as below:
Solution:
Step 1:
1. For SQL Server 2008/2008R2, run a CMD as an admin:
mofcomp "C:\program files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
2. For SQL Server 2012, run a CMD as an admin:
mofcomp "C:\program files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"
3. For SQL Server 2014, run a CMD as an admin:
mofcomp "C:\program files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof"
4. For SQL Server 2016, run a CMD as an admin:
mofcomp "C:\program files (x86)\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"
Step 2:
Re-start the WMI service