Cybersecurity
DevOps Cloud
IT Operations Cloud
ControlPoint 5.x
Situation
DB installation log shows:
Uploading ControlPoint Audit reports ... Copying ControlPoint Audit reports to install directory. ControlPoint Audit reports copied successfully.
Exception when creating folders: System.Web.Services.Protocols.SoapException: The report server has encountered a configuration error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
Resolution
Install Reports Manually
Copy Users\username\AppData\Local\ControlPoint\Temp\Reports to
Program Files\Microsoft SQL Server Reporting Services\Shared Tools
This will contain the English folder and two RSS files.
If you can't find Users\username\AppData\Local\ControlPoint\Temp\Reports then you can copy the Database installer ControlPoint Database Installer.exe to a temp folder.
Rename it to ControlPoint Database Installer.zip.
Extract the zip and you will get a Reports2010 folder with the 2 RSS files and English folder.
You can then copy these to SharedTools as above.
Open a command prompt as Administrator and change directory ( via cd) to the SSRS Shared Tools directory. e.g.
cd c:\Program Files\Microsoft SQL Server Reporting Services\Shared Tools
Run the following command using the RS utility against the Report Server WebService URL,
using the ReportService2010 endpoint (-e parameter), passing also 2 variables – “ControlPoint Reports” (the name of the folder) and the SQL server name.
rs.exe -i CreateControlPointAuditDatasource.rss -s Caution-http://xx.xx.xx.xx/Reportserver -u domainname\username -p mypassword -v parentFolder="ControlPoint Reports" -v servername=SQLServerName -e Mgmt2010
Confirm this runs ok.
Then run the following command to publish the reports. This will output the results to a file called output.txt.
rs.exe -i PublishControlPointReports.rss -s Caution-http://xx.xx.xx.xx/Reportserver -u swinfra\lynckeit -p P@ssw0rd -v parentFolder="ControlPoint Reports" -v reportLocation="English" -e Mgmt2010 >output.txt
Review output.txt and check there are no errors.
If you need more information on the RS utility parameters, just type rs.exe /?
If both commands run successfully you should be able to access your SQL Server Reporting Services page and see the ControlPoint Reports folder after you log back into Reporting.
Check Report Server URLs
After you can see the database and reports created directly in SQL reporting you can then proceed to double check that the Report server entries are setup correctly in the ControlPoint database in order to allow the Audit Reports link in CP to access the reports.
select * from [ControlPoint].[dbo].[CPGlobalSettings]
where settingname like '%Reports%
Check:
Reports.ReportServerReportManagerVirtualDirectory = Reports
Reports.ReportServerRootURL = Caution-http://REPORTSERVERNAME
Reports.ReportServerWebServiceVirtualDirectory = ReportServer
Reports.ReportsPath = /ControlPoint Reports/English
Access Support Article here