Thursday, December 3, 2009

Solved problem with SQL Server Management Studio (SSMS) in Windows 7 X64

I was trying connect to database via SQL Server Management Studio in windows 7, and got following 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)

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