Data Warehousing and Business Intelligence

16 December 2009

Class does not support aggregation

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

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)

Solution:

  • 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: