double hop issue for one db server and not for other

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Administration » double hop issue for one db server and not...

double hop issue for one db server and not for other

Rate Topic

Display Mode

Topic Options

Author

Message

masqazi

Posted Tuesday, February 26, 2013 12:37 AM

Grasshopper

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

prettsons

Posted Wednesday, February 27, 2013 3:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 99, Visits: 1,036

Please follow this discussion: http://www.sqlservercentral.com/Forums/Topic209567-150-1.aspx#bm209604

SQL Database Recovery Expert Smile

Post #1424430

« Prev Topic | Next Topic »

Permissions