Configuring Kerberos so SSRS 2012 reports can consume SharePoint 2010 as a data source

I recently had the need to configure Kerberos constrained delegation for SQL Server Reporting Services 2012 (SSRS) that was running in SharePoint Integrated Mode in a SharePoint 2010 farm.  SSRS reports needed to leverage the “XML” data source and consume the SharePoint web services (such as “listdata.svc”).  The documentation for configuring this scenario is scattered…


Getting the permissions right – SSRS in SharePoint Integrated mode

Recently, I was working on securing SSRS reports when running in SharePoint Integrated mode.  Two settings came back to bite me, so I thought I would blog about them.  You probably already know this, but it is one of those things that you scratch your head over until your memory kicks in.  Anyway, I hope…

3

SSRS reports fail after SharePoint host header change

I came across this issue on a project the other day.  Hopefully this will save someone some time.  While we were waiting for the customer’s DNS czar to add an entry for our SharePoint dev site, we had created a hosts file entry and set up the site using a host header (for sake of…