Tuesday, 12 March 2013

SQL Server Agent gives- Remote procedure call failed (0x800706be)

  • Open the local machine policy using the gpedit.msc interface. Navigate to the policy located at Computer Configuration/Administrative Templates/System/Remote Procedure Call/Rpc Troubleshooting Support/Propagation of extended error information click edit policy setting Enable the policy, and set the field Propagation of extended error information to "On". This process turns the propagation of extended error information on for all processes on the machine. for more details see: http://msdn.microsoft.com/en-us/library/aa373803(VS.85).aspx
  • Update the SQL Server 2008 R2 to SP1
  • Please run the following command if the operating system is 32-bit:

    mofcomp.exe "C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
    On a 64-bit operating system:
    mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof" 
  • If you have SQL Server 2012 running side-by-side on the same machine with SQL Server 2008/2008 R2, then you need to have SQL Server 2008 SP3 or later (or) SQL Server 2008 R2 SP1 or later. This is required to obtain the edition information when performing a SQL Server discovery across the enterprise. I applied SP2 on my SQL 2008 R2 instance and that fixed the issue with configuration manager. If you run into this issue, this piece of information might help you.

No comments:

Post a Comment