Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'

written by Ryan Olshan on Thursday, December 20 2007

I was getting the below error when connecting to a database in SQL Server Management Studio:

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 found this post on MSDN that contained a fix. I had to re-register actxprxy.dll.

Comments

Peter on on 1.03.2008 at 12:58 PM

Who cares? Boring...
Ryan Olshan on on 1.03.2008 at 1:07 PM

Peter,

I'm sure the people who are getting this error care. Otherwise, they wouldn't be searching for this error in the first place.
Justin Stolle on on 1.07.2008 at 5:56 PM

I care because it did just help me. Thanks for posting this, because it was the first thing that came up in Google when I searched for this problem. I was able to fix this frustrating error in a matter of seconds!
Chris on on 1.08.2008 at 12:47 PM

I CARE! Thanks very much for the redirect!
Kevin on on 1.13.2008 at 8:40 PM

haha, what jerk (@Peter). I found your post because I was getting this error. Thanks for saving me the hassle.
FU Peter on on 1.14.2008 at 9:25 AM

Yea... like me!
Deon on on 5.12.2008 at 3:59 AM

Was also getting this error... Thanks Ryan.
David on on 8.26.2008 at 5:28 PM

Thanks for linking to the forums post. The registry merge fixed the issue for me.