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: Tuesday, September 29, 2015 1:44 PM
Points: 189, Visits: 1,343
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