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
Posted Thursday, April 18, 2013 1:22 PM


Group: General Forum Members
Last Login: 2 days ago @ 9:06 AM
Points: 198, Visits: 1,377
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