Unable to cast COM object of type error {6D5140C1-7436-11CE-8034-00AA006009FA}

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: