The best part of the latest service pack release for SQL Server 2005 is the Reporting SharePoint webpart that’s included.

Reporting Services

You can integrate a report server instance with Windows SharePoint Services 3.0 or Microsoft Office 2007 SharePoint Server to store, secure, access, and manage report server items from a SharePoint site. Integration features are provided jointly through SP2 and a special Reporting Services Add-in that you download and install on an instance of the SharePoint technology you are using.

The new Report Viewer Web Part is included in the Reporting Services Add-in that you install on a SharePoint technology instance. For more information about the Web Part and other integration features, see Reporting Services and SharePoint Technology Integration and Features Supported by Reporting Services in SharePoint Integration Mode.

Sources

• What’s New in SQL Server 2005 SP2 (Reporting Services)
• Download Microsoft SQL Server 2005 Service Pack 2