08-08-2012
I got this error today from SQL Server Management Studio. It occurred when I was trying to brows databases by expanding the “Databases” folder in the SQL Server Management Studio navigation tree.
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) I could go around the issue by chosing “Run As Administrator” from the right click menu instead of clicking the icon to Management Studio.
After a lot of search, following command helped me to fix it.
Note that you must run the command prompt as the administrator to run this command (right click on CMD and select “Run As Administrator”).
regsvr32 “C:Program Files (x86)Internet Explorerieproxy.dll
There appear to be many more reasons for this very error. If the above fix doesn’t help, read this forum post which has many more different fixes.
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20
Menol
ILT
I Learnt Today 