Weird SQL Server Management Studio Problem
For the supremely geeky among us…
Recently, my copy of SQL Server 2008 Management Studio began failing with this 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)
(told you it was geeky)
It took me hours and more than a few gray hairs to work this out. Apparently, the issue is caused by installing SourceGear’s Vault Client (Vault is a version control tool used by programmers to manage source code).
SourceGear has a page that talks about it: http://bit.ly/boIRRC
There are various pages online that refer to the error, but the vast majority suggest the solution is to re-register actxprxy.dll. In my case, the trick was to re-register C:\Program Files\Internet Explorer\ieproxy.dll.
The exact procedure:
- Launch a command prompt as Administrator (best bet is to do Start, then search for “Command” to find the icon, then right click and choose “Run as Administrator” — you’ll have to click to approve it)
- Enter the following command:
regsvr32 “C:\Program Files\Internet Explorer\ieproxy.dll”
and press ENTER.
That’s it. 2 seconds.
Wish I had managed to find that one before I spent three hours installing every SQL Server program I could identify and then reinstalling Visual Studio 2010. Uggh.
