SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft .VisualStudio .OLE .Interop .IServiceProvider’. Exception from HRESULT: 0x80004002 (E_NOINTERFACE))

I am working on Windows Server 2008 SP1 Datacenter Edition 64-bit, with SQL Server 2008 installed.

After installing Windows IE8, I got the following error upon starting SQL Server Management Studio (SSMS) 2008.

===== Error 0x80004002 =====

SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

image

===== Solution =====

After a bit of investigation, I found that the registry is somehow corrupted, and the solution is to re-register DLL.

~ Run [ Command Prompt ] (You will need to use the **Run as administrator** option)

~ regsvr32 actxprxy.dll

===== For more information =====

~ SSMS Object Explorer/Server Explorer Error

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20/

~ Windows Internet Explorer 8

http://www.microsoft.com/ie8

7 thoughts on “SSMS – Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft .VisualStudio .OLE .Interop .IServiceProvider’. Exception from HRESULT: 0x80004002 (E_NOINTERFACE))”

  1. Hi,
    I am also having the same issue when I am going to create a custom rendering extension for ssrs. Registering actprxy.dll did not help me in my case. Please share if you have any idea.

  2. Hi Saanj, see if executing the following commands for registering the DLL and OCX files help.

    for %1 in (%windir%\system32\*.dll) do regsvr32 /s %1

    for %1 in (%windir%\system32\*.ocx) do regsvr32 /s %1

  3. I am having same problem with “wuapi.dll”

    i have published the application and this is working fine in my application but same is throwing below exception when tried to rn from remote system [with LAN]

    ************** Exception Text **************

    System.InvalidCastException: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘WUApiLib.UpdateSearcher’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{04C6895D-EAF2-4034-97F3-311DE9BE413A}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

    at WindowsUpdateScannerClient.WindowsUpdateScanner.button1_Click(Object sender, EventArgs e)

    at System.Windows.Forms.Control.OnClick(EventArgs e)

    at System.Windows.Forms.Button.OnClick(EventArgs e)

    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

    at System.Windows.Forms.Control.WndProc(Message& m)

    at System.Windows.Forms.ButtonBase.WndProc(Message& m)

    at System.Windows.Forms.Button.WndProc(Message& m)

    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

  4. I was having the same problem for quite some time and many websites suggested me to re-install the whole itself… but this fix worked for me and it took hardly few mins…

    Thanks,

  5. ROFL…”Somehow the registry got corrupted”. Somehow = Microsoft’s failed regression testing

    Somehow indeed. I had the same problem after installing VS2008 after installing SSMS 2008, but this fix solved the issue.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>