Object Explorer/Server Explorer Error

Object Explorer/Server Explorer Error

• Schmlughtz

  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.
  

• Kyderoy

  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,

  
  

• minimi

  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.
  
  

• Gideon Raveh

  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
  

• Brad House

  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)

  
  

• Gavin McKay

  Did not help me. I checked reg and made sure everything is there. But I still get the same problem. Please help!
  
  

• nielsvdc

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

  
  

• xanthus

  I have no words to thank you enough!!
  
  It worked flawlessly.
  
  You saved me lots of headaches.
  
  -- EduQuint

  
  
  

• Schu

  Perfect, that did it. Thanks!
  

• HemlataArcot

  Thank - You, registering the actxprxy.dll fixed the error for me :)
  
  
  

• khawari

  Thanks a lot! Nick, that appears to have fixed the problem.
  

• fabianus

  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
  
  

• teresal

  Thank you so very much. This fixed my problem.
  
  John
  
  

• y2k4life

  Solved my problem with Team System as well as Sql Server 2005. 
  
  Thanks Nick.  Lifesaver.

  
  
• Object Explorer/Server Explorer Error