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 have tried all the solutions I found in the internet:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20
But none of them works for me.
However, I finally got the problem solved by removing my anti-virus software AVG 9.5.
Hope this will help other people.
Update:
The same problem back again after I disable UAC, and restart computer.
I have to enable UAC again to fix it.
Update 2:
There is an easy way to fix is just to run SSMS as administrator
There is an easy way to fix is just to run SSMS as administrator
