SQL Server Management Studio 2005 – Unable to cast COM object… IServiceProvider, etc.etc.

Posted: 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 FilesInternet Explorerieproxy.dll"
            32-bit:  regsvr32.exe actxprxy.dll
            64-bit:  regsvr32 "C:Program Files (x86)Internet Explorerieproxy.dll"
            64-bit: (this one I haven’t verified for 64-bit):  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