Object Explorer/Server Explorer Error

I have just installed the released VS2005 as well as the released SQL2005. When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error:

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)).

Does any one have possible solutions for me Any help would be greatly appreciated.

--Nick

Answer this question

Object Explorer/Server Explorer Error

Hans K.
Copy the text inbetween the two copy markers and save them to a text file with any name and a ".reg" extension. Right click on the file you just created and select "Merge".

Hope this helps,
--Nick
garrywilliam
Try re-registering actxprxy.dll (in system32\). I had this problem, and the root cause was that the path to this dll in the InProcServer registry key was wrong. I have no idea how it got corrupted, but running regsvr32 on the dll fixed it.
Sveer
Hi All,

I am getting this error

"Unable to cast COM object of type 'System.__ComObject' to interface type
VSLangProj.VSProject'. This operation failed because the QueryInterface
call on the COM component for the
interface with IID '{2CFB826F-F6BF-480D-A546-95A0381CC411}' failed
due to the following error: No such interface supported (Exception
from HRESULT: 0x80004002 (E_NOINTERFACE))."

while working with VS2005. I added a test project and included a web test. The test is running for the first time but when I close the application and open that again and try running the test it is showing this error. I have repaired VS2005 also but nothing is working.

Could anyone help me in solving this...
Thanks in advance,
Konrad L. M. Rudolph
I've got the exact same error. And I've tried uninstall / reinstall SQL 2005, SQL 2000, uninstall / reinstall Client Component where the Management Studio is located, and even uninstall / reinstall VS2005, VS2003 with NO luck and NO clue to get it going.

Can someone shed some light on this issue

===================================

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)

------------------------------
Program Location:

   at Microsoft.VisualStudio.OLE.Interop.IServiceProvider.QueryService(Guid& guidService, Guid& riid, IntPtr& ppvObject)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ServiceProvider.GetService(Guid guid, Type serviceType)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ServiceProvider.GetService(Type serviceType)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.GetService(Type svcClass)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.System.IServiceProvider.GetService(Type serviceType)
   at System.ComponentModel.Design.ServiceContainer.GetService(Type serviceType)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetService(Type serviceType)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.GetService(Type serviceType)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
wantedNooby
Did not help me. I checked reg and made sure everything is there. But I still get the same problem. Please help!
Joe Barbian
Worked for me too, perfectly! THANKS! This needs to be made easier to find on the web...

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)

------------------------------

Program Location:

at Microsoft.VisualStudio.OLE.Interop.IServiceProvider.QueryService(Guid& guidService, Guid& riid, IntPtr& ppvObject)
vogue
Thank - You, registering the actxprxy.dll fixed the error for me :)
Code Digger
Thanks a lot! Nick, that appears to have fixed the problem.
Johan Bombaye
I have a solution for the problem, but I still do not know why it was a problem to begin with. It seems that the IServiceProvider COM object is not registered on the system. I went to a system that this was working properly and exported the following registry entries:

[Copy from HERE]
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"
[ ... TO HERE]

Merging them on the broken system fixed the problem. I would still appreciate anyone shedding some light on the situation, but it works for now.

--Nick
CodeDoctor
Solved my problem with Team System as well as Sql Server 2005.

Thanks Nick. Lifesaver.
Lino&#33;
I'm having the same problem. How do you go about "merging" the registry results you have above into a new registry

Thanks in advance.
J&#233;r&#244;me Bonnet
I have no words to thank you enough!!

It worked flawlessly.

You saved me lots of headaches.

-- EduQuint
wiedemeyer
Perfect, that did it. Thanks!
Mcmac
Thank you so very much. This fixed my problem.

John
Object Explorer/Server Explorer Error

Answer this question