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

Published Fri, Mar 20 2009 22:48 by Martin Poon
Filed under: ,

Comments

# Saanj said on 06 April, 2009 08:19 AM

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.

# Martin Poon said on 06 April, 2009 09:10 AM

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

# ANGGAMG said on 15 June, 2009 03:04 AM

thnx, this works for me

# Nabin said on 23 June, 2009 06:12 AM

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)

# Rejishankar said on 10 July, 2009 05:22 AM

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,

# Jijesh V R said on 14 July, 2009 05:35 AM

i was also facing the same problem. And it worked for me:)

Thanks

Jijesh

# JS Cole said on 20 July, 2009 02:23 PM

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.