SQL Server Configuration Manager returns remote procedure call failed I open the SQL Server Configuration Manager and it returns remote procedure call failed.



This is Windows 7 Ultimate version, SQL Server 2008 R2 Express version with advanced services.

Previously I installed SQL Server 2008 R2 Express version and since I needed the full text search I uninstalled SQL Server 2008 R2 Express and then installed SQL Server 2008 R2 Express with advanced services.

P.s my RPC background service is running.

I executed the following command and it returned an error:

 C:\Users\venkat&gt;mofcomp.exe "C:\Program Files (x86)\Microsoft SQL    Server\100\Shared\sqlmgmproviderxpsp2up.mof"

 Microsoft (R) MOF Compiler Version 6.1.7600.16385
 Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
 Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof
 MOF file has been successfully parsed
 Storing data in the repository...


Error:


  An error occurred while processing item 1 defined on lines 4 - 7 in file C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof:
  Error Number: 0x80041003, Facility: WMI
  Description: Access denied
  Compiler returned error 0x80041003
In my case there were two instances of the "SQL server Configuration Manager" in SysWOW64. Only the latest version worked. The other version produced the RPC error message. 

C:\Windows\SysWOW64\mmc.exe /32 C:\WINDOWS\SysWOW64\SQLServerManager10.msc FAILED
C:\Windows\SysWOW64\mmc.exe /32 C:\WINDOWS\SysWOW64\SQLServerManager11.msc WORKED