Wednesday, 31 August 2016

Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012

SQL: You may end up getting "The remote procedure call failed. [0x800706be] WMI Error" when you click SQL Server Services in SQL Server Configuration Manager as shown in the snippet below.
This error pops-up when you have SQL Server 2008 or SQL Server 2008 R2 running along with SQL Server 2012 on the same machine OR you have installed Visual Studio 2012 OR while activating SharePoint 2013 features OR by activating any of the additional components you want to activate on the back-end machine (SQL 2012 & above) which thereby automatically installs SQL Server 2012 components.

One of the solution is to recompile MOF File to resolve "The remote procedure call failed. [0x800706be] WMI Error"
for this ..Open command prompt under administrative privileges i.e., using "Run as Administrator" and execute
mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

Now, you can go ahead and open SQL Server Services under SQL Server Configuration Manger to see all SQL Server Services

BUT, in some cases we have experienced this may not turn out success for you.
So, make sure the SQL Server Configuration Manager which you are trying to OPEN is from the right executable version (SQL2008 or SQL2012) as there will be two executable files. So if you try to open the shortcut on a SQL 2012 installed machine you will definitely end up with EMI Error.. All what you can do is UNPIN and PIN the right executable.

0 comments: