Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, February 26, 2013 12:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:36 PM
Points: 114, Visits: 1,224
Please follow this discussion: http://www.sqlservercentral.com/Forums/Topic209567-150-1.aspx#bm209604

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

Add to briefcase

Permissions Expand / Collapse