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?
View Complete Post