Today one of my colleagues contacted me and had problems with the “Report sales tax for settlement period” report in one of our environments. It worked last friday bur not today. The error message was this:
When I looked for the Session ID in the Environment monitoring in LCS, one of the errors I got was this one:
Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version
and another one was:
TmpTaxReportById_TaxReportField on table TaxReportTmp_SE.
I already knew this was related to SSRS (Reporting Service) so obvoiously I began with restarting the Report Server, it did not help.
Since the environment is a Microsoft Hosted Tier-2 environment the first error was really strange… why should Microsoft supply an incompatible SSRS server… Not likely…
Another error I got was an authentication error… this made me think that there was something wrong with the AOS. I tried restarting the IIS Server… It helped !!!!!