title: SSRS Double Hop Authentication?
body: <p>I have created reports on SQL 2008 R2 Server and deployed the reports and data source to the same server. The data source uses a database residing on a SQL 2005 server. Also looking to use Windows Integrated security.</p>
  
  <p>Similar to many other posts - when trying to run the reports on workstations or servers (other than the 2008-R2 server that also has the reporting services) I get the error:
  An error has occurred during report processing. (rsProcessingAborted)
  Cannot create a connection to data source 'MemberFeeDetails'. (rsErrorOpeningConnection)
  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</p>
  
  <p>Q:Would this scenario be considered a Two Hop Authentication issue and thus require the Kerberos Authentication? If that is the case, then I will look to set up the Kerberos Authentication. All comments are welcome.</p>