I have been using SQL Server 2008 R2 on my development machine for a long time. It is working well and I had changed sql server settings through Sql Server Configuration Manager many times ,it was worked well. But today when I open SQL Server Services entry in Sql Server Configuration Manager, it shows an error message saying The remote procedure call failed 800706be.
After analyzing my personal work in that machine for the past few days, I have realized and confirmed the reason for this issue (The remote procedure call failed 800706be.) is installation of Microsoft Visual Studio 2012. Yes, this error occurs only after I have installed the Microsoft Visual Studio 2012 setup in my work machine.
Since it is being a WMI error, I recompiled the MOF file –> mofcomp.exe “C:\Program Files (x86)Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof”
I also un-registered and re-registered the sql provider DLL –> regsvr32 “C:\Program Files (x86)Microsoft SQL Server100Sharedsqlmgmprovider.dll” but issue not resolved.
Solution or Fix: The remote procedure call failed in Sql Server Configuration manager
I have applied SQL Server 2008 R2 SP2 on my SQL 2008 R2 instance and that fixed the issue with Sql Server Configuration Manager. You can download setup from here… SQL Server 2008 R2 SP2 .
Related Articles
– Event ID 4656 – Repeated Security Event log – PlugPlayManager
– Event ID 1046 – DHCP Server
– Event 4624 null sid – Repeated security log
– Event ID 1014 Name resolution for the name cyber-mind.info timed out after none of the configured DNS servers responded
– Event ID 7036 service entered the stopped state – Service Control Manager
– Event ID 5156 Filtering Platform Connection – Repeated security log
– Event ID 1059 – The DHCP service failed to see a directory server for authorization
Thanks,
Morgan
Software Developer
Thank you so much for posting your solution!!! I too ran into the same problem and after trying many different things to no avail, your solution did the trick!
sir how do you recompile?
sorry for the late reply, actually I am not suggesting to recompile the MOF file.. my suggestion is just apply or install the SQL Server 2008 R2 SP2 on SQL 2008 R2 instance. You can download setup from here… http://www.microsoft.com/en-us/download/details.aspx?id=30437
An easier (IMO) and a more effective solution is explained here http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed
there are 5 file. which file should i choose ??? pls help m
Do you mean download link? …if so, you can choose any of the file depends on your processor architecture….like..if you have 64 bit based system, just select the file 'SQLServer2008R2SP2-KB2630458-x64-ENU.exe' and proceed Next
ya, I choose x86. I setuped sucess but It 's not replace my SQL.Now, there 2 folder," Microsoft SQL server 2008" and " Microsoft SQL server 2008 R2". pls help me, I cant fix it :