I have been using my new Windows 7 machine for the last few days and have hit a few problems getting things set up. Fortunately, I have managed to work around most of them. This was one of the first ones.
I was using Microsoft SQL Management Studio 2008. When I attempted to pop out the list of databases on a server in object explorer, I got the following error: -
“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: 0×80004002 (E_NOINTERFACE)).”
After a little research, I found several pages with different solutions to the problem. A common thread is that it seems to involve SourceGear Vault Client (source control software). I suspect that this is only a problem for people who are using old versions of it (I’m using the spectacularly old version of 2.0.6!).
The solution which finally worked for me was to copy the Vault client folder, uninstall Vault, copy it back and make manual shortcuts. Then, in order to register it as a source control provider, I used the following registry file: -
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceCodeControlProvider]
"ProviderRegKey"="Software\\SourceGear\\Vault Client"
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceCodeControlProvider\InstalledSCCProviders]
"SourceGear Vault Client"="Software\\SourceGear\\Vault Client"
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceGear]
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceGear\Vault Client]
"SCCServerName"="SourceGear Vault Client"
"SCCServerPath"="C:\\Program Files (x86)\\SourceGear\\Vault Client\\VaultIDE.dll"
To use a registry file, you need to copy and paste the code into a new notepad file and save it with a .reg extension. When you double click on it, Windows will ask if you want to add it to the registry. You may need to change your SCCServerPath before saving the file.
Thanks to Henrik Bruun’s post on this page for the registry fix.
No related posts.
Tags: 64 bit, Error, SMSS, SourceGear Vault, SQL Management Studio, Windows 7, x64
You are the man, I’ve been looking for a fix for this since last month’s upgrade to Win7 and SQL 2008. It has been driving me insane having to remote into the database server just to use SSMS. We’re using Vault 3.1.9 and had the same issues. Crazy I was looking for it today, and you posted this just today.
Glad it was of use to someone!
Thanks for the solution. It helped me too. The only thing is that SourceVault doesn’t show up in Programs and Features now. So there is no way to uninstall it …
Yes, but all you need to do to revert the “install” is to delete the folder and remove the registry entries.