A) Both the LIVE and TEST match in the Advanced Settings. Should there be a ‘Physical Path Credentials’?
B) Application Pool Identity match for LIVE and TEST
C) the web.config files did NOT match for LIVE and TEST. TEST was missing the SSRSBaseURL altogether, so I copied that line from the LIVE config to TEST config.
That has changed something, I now get a different error when running a report in TEST.
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘OrderHed’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
I will reboot the servers tonight when there are no users online and test again.
Thank You for the excellent suggestions Jason and Olga.