Class does not support aggregation

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()Hi there,
I'm using SQL Server 2005 Dev. with Windows XP Pro. SP2.
50GB free space with 1GB of RAM
After I installed SQL Server with no problems.
I tried to open a table in AdventureWorks database and I'm getting an error:

Could some one tell me what is going on ?
Thanks an advanced
Oded Dror
Email: odeddror@.cox.net

I am using SQL Server 2k5 Dev Management Studio. I connected to SQL 2000; created a table with TSQL (using Query Editor); and then when I try to open it using Management Studio's "Modify" context menu option I am getting the same exception.

The table is opening fine in SQL 2000 Enterprise Manager, and I am able to update its definition using SQL2k EM's table designer.

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

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

|||Hi, did you guys solve this error by any chance? I'm getting it too, but my coleague who is working on a machine with the same configuration as mine, he is not receiving this error. Any suggestions?|||I also am stuck with the same error, has anybody solved this issue?|||

Found a FIX

I found another post that suggested this:

Remove Workstation componenents, then do a repair on Net Framework 2.0 then Re-Install workstation components. This worked for the other poster, I just tiried the same and it also worked for me.

I suggest following that exactly, I had had previously just done a repair on Net Framework and that did not help, I also had just re-installed workstation components and that hadnt worked, only the combination above worked for me.

|||Hi, Can you post the link? Thanks

- MLynch|||Very well! It helped me too!|||

Works for me too....

Used http://support.microsoft.com/default.aspx/kb/306160 to repair.

sqlsql