• Networking: The investigation is still on the way, we've switched to backup telecom carriers since the episode but we're still working in settling everything as it must be. We'll add more updates as we have them available. Incoming and outgoing emails will be restricted, and user registration has been disabled until the issue is resolved.

Can't open database - doesn't support aggregation

Newbie Spellweaver
Joined
Aug 4, 2006
Messages
88
Reaction score
0
Location
Canada
I cannot seem to open the database tables for editing. When I right click on a table and go to "Open table", for example on dbo.Accounts, I receive the follow message:
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
etiolated - Can't open database - doesn't support aggregation - RaGEZONE Forums


Please advise. :)
 

Attachments

  • cantopen - Can't open database - doesn't support aggregation - RaGEZONE Forums
    cantopen.webp
    8.9 KB · Views: 146
I've found the fix, in case anyone else encounters this.

Various other posts suggest repairing .NET 2.0, I did this as well, when I went to repair the installer crashed, perhaps a good sign that my .NET 2.0 was also somewhat corrupt. I uninstalled .NET 2.0 from Add/Remove programs, and re-installed it, and then repaired it to make sure that worked (which it did).

Then I went and tried to open the table, but it still failed. So as the other posts suggested, I uninstalled all the workstation client tools, and just left SQL Server 2005. I went and installed Server Management Studio Express since I didn't have a version of it anymore, connected, and voila! The table opened, so hopefully tomorrow I can begin creating my server. :)
 
Upvote 0
Back