I have Reporting Services installed on one server and the databases for it are hosted on another instance of SQL which is on a different server. I can run reports just fine when I'm on the server in which Reporting Services is installed. However, when I navigate to the Report Manager on my local machine and try to run a report I get the error
- An error has occurred during report processing. (rsProcessingAborted)
- Cannot create a connection to data source 'xxxxx'. (rsErrorOpeningConnection)
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
Database xxxxx makes sense because that's where the dataset of the report is configured. I look at the logs and find this message
ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'xxxxx'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Here is where I'm confused because I'm using a SQL Account that is a sysadmin to connect to the Report Server Database. I'm not sure why it's coming across as anonymous but it is an issue because users cannot run reports from their own machines. Do I need to make a change to the connection?