SQLServerCentral / Reporting Services / Reporting Services 2005 Administration / double hop issue for one db server and not for other / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:09:41 GMT20RE: double hop issue for one db server and not for otherhttp://www.sqlservercentral.com/Forums/Topic1423906-162-1.aspxPlease follow this discussion: http://www.sqlservercentral.com/Forums/Topic209567-150-1.aspx#bm209604Wed, 27 Feb 2013 03:24:14 GMTprettsonsdouble hop issue for one db server and not for otherhttp://www.sqlservercentral.com/Forums/Topic1423906-162-1.aspxi 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 hopeverything 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 messageAn error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'dbsrv'. (rsErrorOpeningConnection)Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'Tue, 26 Feb 2013 00:37:05 GMTmasqazi