Wednesday, October 13, 2010 1:47 PM
I am trying to run a SSRS report directly from SharePoint, but I am running into an authentication issue.
The report has a data source on a separate box from the SharePoint server and since I am using NTLM it is causing an issue with a double hop.
Windows is not able to pass the user's credentials from the SharePoint server to the SQL Server if you are using NTLM authentication.
A fix would be to implement Kerberos, but that brings in other issues and adds another level of complexity to the system.
Is there a workaround where I can get access to the database on the separate box without using Kerberos?
Wednesday, October 13, 2010 1:52 PM
You could check this post out
I believe this answer is in the last message.
MSTS, SharePoint tips blog: http://buyevich.blogspot.com
Thursday, May 10, 2012 1:28 PM
This video explains SharePoint 2010 with SSRS 2012 and Kerberos configured better than anything I've seen thus far:
Thursday, May 10, 2012 6:21 PMAnother option would be to change the Operating mode of Reporting Services to Trusted account (not required for 2012 RS), and then use a low privilege proxy account in the connections for those reports. Control access to your reports/data connections through SharePoint security. Not sure if this is an option for you, but it does work.