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.