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?