i have report server/iis installed in one machine and different db servers (locally on another machines and in branches ). to use windows authentication in reports, we configure as per double hop
everything is working fine when reports are using data from branch db server...but when reports need data from local db server (on another machine) it give same error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dbsrv'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'