Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.
Steps I perform to resolve the issue, Seems to be a WMI error :-
1) If using Window Server 2008 & above, Run command from command prompt to verify WMI repository : winmgmt /verifyrepository
If you got any error, Please contact your OS team for WMI rebuild.
2) Recompiled the MOF file –> mofcomp.exe "C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof"
3) Re-registered the SQL Server provider DLL –> regsvr32 "C:Program FilesMicrosoft SQL Server90Sharedsqlmgmprovider.dll"
4) Your issue should be resolved now. If you still face same issue that means there are chances that you may be running with different versions of SQL Server. If yes, Please try to patch SQL Server Management Studio (SSMS) with latest available Service pack.
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
please help to solve this Error for SSMS Configuration. I have followed the same steps as described by you. But, Problem still exists.
Hi Dhani
Please share :-
1) Screen shot of error
2) Screenshot of each steps output
3) Version of SQL Server you are using
I have same problem
When I try to compile mof file it says ‘file not four’
I checked and file was missing … What should I do now..
Hi Zubair
Which version of SQL Server you are using?
Try to search *.mof in installation drive. I face that .mof file location is diffrent according to versions. You can search *.mof & after finding required file change the file location in command to compile it.
This does not work for me. I’ve successfully registered mof and dll and repaired SQL Server 2014 installation and it still doesn’t work. I am using Windows 10.
are you using multiple versions of SQL server on same machine?
Still I did not get change to test things on WIn 10.
[…] http://mssqlfun.com/2014/09/29/sql-server-configuration-manager-giving-error-the-remote-procedure-ca… […]
[…] SQL Server Configuration Manager giving Error – MSSQLFUN – Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I … […]
[…] SQL Server Configuration Manager giving Error – MSSQLFUN – Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I … […]