SQL Server Configuration manager is the important and preferred tool to make any changes to the SQL Server Services configurations related to changing SQL Service account password, Changes to Network Protocols, Enabling SSL, Changing SQL Server startup parameters, etc. This gets installed when any SQL Server components are installed on the server.
On servers with multiple SQL Server instances, same or different versions sometimes uses same files for configuration manager, thus sometimes causes problems or failures in opening the SQL Server Configuration manager.
Below is one of the common error which occurs on servers where there are multiple SQL Server instances of different versions or architectures are installed or uninstalled later, after which there are errors while opening SQL Server Configuration Manager.
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace [0x8004100e]
This error occurs mostly because the WMI provider is either removed when you uninstall an instance of SQL Server or may have got corupted during installation of SQL Server or other related components.
To resolve this problem follow the below steps.
– Open a command prompt by choosing “Run-as-Administrator”
– Change the directory to C:\Program Files
– Type the below command and change the number in the command to respective SQL Server version. Refer below for the correct number to use for the latest SQL Server version installed.
mofcomp “%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof”
– Run the command by pressing Enter, which should complete without any errors.
– Close and open the SQL Server Confutation Manager by choosing “Run-as-Administrator”
The value of number depends on the version of SQL Server Version
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90
After following the above steps the issue will be resolved mostly.
What is SQL Server Configuration Manager?
SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager10.msc(10 is related to SQL 2008 or R2 and will be different for other versions) file in the Windows System32 folder to open SQL Server Configuration Manager.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.