SQL Server Management Studio 2005: Unable to cast COM object IServiceProvider

In Windows Tags #sql-server Published 10/22/2010

  • Application: SQL Server Management Studio 2005
  • •OS: Windows 7 Enterprise, 32-bit
  • Error Message: 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)
  • Action: Occured when connecting to a database server from the GUI.
  • Cause: Installing SourceGear Vault Client (in my case, 5.0.4 build 18845).

Fix 32-Bit:

regsvr32 "C:\Program Files\Internet Explorer\ieproxy.dll"
regsvr32.exe actxprxy.dll

Fix 64-Bit:

regsvr32 "C:\Program Files (x86)\Internet Explorer\ieproxy.dll"
regsvr32.exe actxprxy.dll

The following links were helpful in my search to remedy this problem:

  1. http://msmvps.com/blogs/martinpoon/archive/2009/03/20/ssms-unable-to-cast-com-object-of-type-system-comobject-to-interface-type-microsoft-visualstudio-ole-interop-iserviceprovider-exception-from-hresult-0x80004002-e-nointerface.aspx
  2. http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20
  3. http://support.sourcegear.com/viewtopic.php?f=5&t=12680&p=58966#p58966

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.