TITLE: Microsoft SQL Server Management Studio
------------------------------
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
------------------------------
Solution:
Remove Workstation componenents, then do a repair on Net Framework 2.0 then Re-Install workstation components.
Steps to Remove Workstation componenents and repair the .NET Framework installation
1. Click Start, click Control Panel, select Add or Remove Programs:
Find Microsoft SQL Server 2005 and click remove.
On the window check Workstation Components, click Next..etc
(Don't worry it wont delete the whole installation only this component)
2. Before repairing .Net Framework 2.3,You must 1st obtain the original installation source. For example, if you installed the .NET Framework from a CD-ROM or from a DVD, insert that disc. If you downloaded the .NET Framework , download the .NET Framework again. Make sure that you click save to disk. If you installed the .NET Framework from a network share, reconnect to that share.
3. Back to Add or Remove Programs select Microsoft .Net Framework 2.0
and click change/remove button, and select repair.
The Microsoft Windows Installer will verify and repair the .NET Framework installation.
4. Reinstall Workstation Components by obtaining the original installation source. You can select all available components or just the Workstation Components in the installation process.