Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

double hop issue for one db server and not for other Expand / Collapse
Posted Tuesday, February 26, 2013 12:37 AM


Group: General Forum Members
Last Login: Wednesday, February 27, 2013 2:48 AM
Points: 14, Visits: 26
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'

Post #1423906
Posted Wednesday, February 27, 2013 3:24 AM



Group: General Forum Members
Last Login: Monday, December 5, 2016 11:54 PM
Points: 177, Visits: 1,378
Please follow this discussion:

SQL Database Recovery Expert
Post #1424430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse