SQL 2005 woes

SQL 2005 woes

• Johann

  TITLE: Microsoft SQL Server Management Studio
  ------------------------------

  Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)

  ------------------------------
  BUTTONS:

  OK
  ------------------------------
  

  
  

• Frank_9

  I know you don't want to hear this but I would really suggest doing a clean format here. If the problem still persists you may be looking at a hardware instability or some sort of odd software compatibility problem.
  
  

• whinkle

  It happens when I create "the most basic" table, or open an existing table.  Yet when I do the equivalent from within the VS 2005 Server explorer, I can do create or view data with no problems.
  

• RajanSelliah

  You are correct - I don't want to hear that!  Maybe if enough people have a similar problem, a semi-official fix will be issued.  Moral of the story: Never install beta software in a "production" partition.
  

• getter

  I DID follow these instructions - are there are several similar but not identical uninstallers from Microsoft.  I thought they worked - apparently they did not.  Having to reformat my hard disk because the beta software didn't quite uninstall seems Draconian.
  

• Wesley P

  I know this is not the proper place to post this question but it's been more than 2 week since I posted this and I need help here. please see my post at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=138465&SiteID=1
  
  anybody there who wants to help me out
  
   
  
  
  

• Chorch

  When I open the table designer - I never get the chance to design a table.  I also get the same error when I open a database diagram designer, or try to return the data from the table (open a table) - yet if I do a select script, I can run this fine.  Also all the equivalent designers work fine in VS 2005
  

• Robert McKee

  Is this the complete error message   You maybe able to click-on the icon at the bottom of the error dialog to copy the complete error to the clipboard.
  
  Peter
  
  

• acexman

  I am running the RTM versions of both products.  I also did uninstall VS 2005 Beta 1 sucessfully before installing the RTM products.
  

• _phil

  When do you get this error Do you get the error on opening the table designer to create a new table, or on saving a new table
  
  Peter
  
  

• bshalton

  Does this happen when you create the most basis table   If not, what is the composition of this new table
  
  Peter

  
  
  

• BMakari

  I'm also getting this error:
  
  ===================================

  Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)

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

     at Microsoft.SqlServer.Management.UI.VSIntegration.ISqlToolsVSHlpFactory.CreateHierarchyWrapper(Guid& clsidInnerHier)
     at Microsoft.SqlServer.Management.UI.VSIntegration.SqlWorkbenchHierarchy.CreateHierarchyWrapper(Type typeToWrap, ILocalRegistry localReg)
     at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.get_SqlVirtualProject()
     at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeDesigner(IManagedConnection connection)
     at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()
  
  I get it whenever I :
  
  Select 'New Table', 'Open Table', 'Modify',  from the context menu of a table object.
  
  It also happens when clicking 'Modify' on a item under 'keys'

  
  

• Jigar acharya

  Please verify that you are running the RTM versions of both, not the RC or CTP releases.  Also, if you have had beta releases installed I would suggest a clean format first.
  
  

• _Rico_

  There are several forum threads here in the MSDN forums related to a complete uninstall of former beta versions of SQL Server 2005 and Visual Studio 2005 (example: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=137700&SiteID=1).  Have you tried these   Note, the order of uninstall of components is particularly important, and there are some logs you can check as outlined in the post.  Let me know if this helps, I'd like to help get to the root of your issue.
  
  Also (from the shameless promotion department) - Virtual PC is a great product for enabling testing of beta software.  I've got multiple Virtual Images with beta setups on my harddrive and can call them up and experiment with them very easily, without changing the config on my working machine.
  
  Thanks, MJ
  
  
• SQL 2005 woes