Wednesday, 16 October 2013

The remote procedure call failed in Sql Server Configuration manager - Event ID: 1000


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.

Fix error: The remote procedure call failed in Sql Server Configuration manager

While analyzing event log, got the following error log with the Event ID 1000.

Fix error: The remote procedure call failed in Sql Server Configuration manager

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 Server\100\Shared\sqlmgmproviderxpsp2up.mof"

I also un-registered and re-registered the sql provider DLL –> regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmprovider.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







Advertisements
Advertisements

7 comments:

  1. 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!

    ReplyDelete
  2. Replies
    1. 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

      Delete
  3. An easier (IMO) and a more effective solution is explained here http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed

    ReplyDelete
  4. there are 5 file. which file should i choose ??? pls help m

    ReplyDelete
    Replies
    1. 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

      Delete
    2. 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 :

      Delete