SharePoint and Reporting Services integration

I’m currently working on a SharePoint project, where we have to run some Reporting Services reports on the SharePoint data as well as data from a DB2 database.

The tricky thing is that SharePoint site is public available to known users, but how to handle authentication with Reporting Services??

Well - Microsoft fixed that for you in SP2 for SQL Server 2005, where they introduced a feature called Reporting Services in SharePoint Integration Mode

I’m still in the early adoption fase, but it looks pretty promising to me - decide for your self…

http://technet.microsoft.com/en-us/library/bb326290.aspx

Tags: Reporting Services, SharePoint