SharePoint SSRS and NTLM/Kerberos

Question

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?

Any Ideas?

Answer 1

Hi,

You could check this post out

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1bb91f18-dc78-4b91-bf22-6ef74b6a699d

I believe this answer is in the last message.

Regards,

 

 

---

Vladimir Buyevich
MSTS, SharePoint tips blog: http://buyevich.blogspot.com

Answer 2

This video explains SharePoint 2010 with SSRS 2012 and Kerberos configured better than anything I've seen thus far:

http://technet.microsoft.com/en-us/edge/Video/hh858469

Answer 3

Another 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.

---

John