Double hopping issue with the SSRS

This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"

Trying to troubleshoot double hopping issue with the SSRS. The problem is complicated when report services app server separated from the data source database. The authentication only fulfil at the client to the reporting server but then stop there, while another authentication is still necessary to authenticate between the app server to the database.

Got the integrated security works on SSRS. The after the work done on: (1) setting up the SPN for report server and SQL server, (2) setting up the delegation cross apply against the services account, (3) change the authentication method to Kerberos as first considered method in RsReportServer.config. It is then amazingly works.