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

Reporting Service 2008 & 2005 (together) Expand / Collapse
Author
Message
Posted Thursday, April 18, 2013 1:22 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:44 PM
Points: 152, Visits: 1,170
I'm trying to run Reporting Service on ServerA (a 2008 R2 box) which is retrieving data on ServerB (a 2005 box) I'm receiving the error message:
Cannot create a connection to data source ' '. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
When I try to run the report from Report manger on ServerA. I notice when I open Report Builder on ServerA and test the datasource it connects with no problem. Is there a double hop issue which I having, what could be the problem why the report won't run?
Post #1444115
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse