Data Warehousing and Data Science

16 December 2009

Class does not support aggregation

Filed under: SQL Server — Vincent Rainardi @ 4:51 pm

I experienced this error message: “Message: Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))”

When: this message appear when I tried to open an SSMS solution. In this case it’s a SQL Script solution (relational).

Env: XP SP3, SQL 2k8 RTM

Background: A few days ago I uninstalled a lot of VS2005 stuff and SQL2005 stuff from Control Panel (as I’m using VS2008 and SQL2008)


  • I went to Control Panel and clicked remove/change on SQL Server 2008, selected remove, selected Management Tools basic and advanced and removed them.
  • Then I clicked remove/change again on SQL Server 2008 on Control Panel, selected add, selected Management Tools basic and advanced (and I also select SSIS and SSRS and Sync — I didn’t know I must have uninstalled them unintentionally) and added them back.

After that I can open the solution without any problem, just like last week.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: