When validating the Report Server connection parameters in the UI admin Report Configuration page, the message can occur
"The validation of the Report Server connection failed. This could be due to the Report Server being offline"
After clicking "OK" the message
"Error: Configuration was not saved due to a database connection failure." is displayed.
The Report Configuration parameters are stored in the AdminConfiguration table in the SAMStore.
To check if the parameters entered in the "Report Configuration" UI Admin page have been correctly updated in the
AdminConfiguration SQL table, the SQL query below can be run
SELECT * from [SAMStore].[dbo].[AdminConfiguration] where ConfType like
If the parameters are correctly listed and the reports can be accessed, the validation message is probably
It may be occurring because of a corrupt/badly compiled version of the loadjsonReportService.jsp file.
Run the steps below and check if they resolve the validation error message
- stop the UI service
- delete the folders below
- start the UI service