SharePoint Reporting Services Integration

Yet again I find myself trying to debug a SharePoint Reporting Services Integration and each time I go searching the internet for the same blogs and guides to help me.  So I thought it would be a great idea to post all the links here then I can refer back to them and save myself some Googling time!

 

Fantastic overview by Jesper M. Christensen on how Kerberos works in a SharePoint/Reporting Services Integration

 

Troubleshooting articles from the same author as above

 

A blog entry by Martin Kearn detailing the steps required to enable Kerberos in a MOSS 2007 environment

 

Microsoft guide to Configuring Reporting Services for SharePoint 3.0 Integration

 

Getting it to all play nicely together can be a real pain but it can and does work, one of the most painful things can be getting the right SPNs set up – For this I would recommend the DelegConfig tool created by brian-murphy-booth, make sure you get the right one depending on whether you have IIS 6 or 7.

 

Make sure you add the DelegConfig web application to the same website in IIS that is hosting the front end you are trying to debug (i.e. SharePoint).