- 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:
- 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
- http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20
- http://support.sourcegear.com/viewtopic.php?f=5&t=12680&p=58966#p58966