Posted on 2:04 AM by Softminer and filed under ,

usually its better to install vault (source gear) after SSMS otherewise installing vault will cause an error in running SSMS.

The server returned 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: 0x80004002 (E_NOINTERFACE)).

to fix this error you need to register this dll's again


For example, click on Start, and then choose Run, and in the Run dialog type:
dont forget to run cmd as administratore:

regsvr32 Urlmon.dll

try it first in %WinDir%\SysWOW64 and if it doesnt work try %windir%\system32 folder.

after this maybe you have this sideeffect that cause you explorer to open the folders alway in new page.

to solve this :

regsvr32 "%programfiles%\Internet Explorer\ieproxy.dll"
regsvr32 "C:\Program Files (x86)\Internet Explorer\ieproxy.dll"

to solve the SSMS and vault in Windows x32 do following step:

copy this text in .reg file and run it

Windows Registry Editor Version 5.00

Responses to ... SQL Server Management Studio failed after installing vault on 64 bits