How to remove resources and drop the Database without uninstalling and reinstalling the Report Server?
At any time, you can remove the resources that were created in the Report Server and drop the Report Server database without uninstalling the Report Server setup from the Control Panel.
By doing this, you can remove the test reports that you have created for evaluating the Report Server or can re-configure the Report Server with SQLCE or SQL Server.
Report Server is deployed in the below location by default.
{Windows_Drive}\Syncfusion\Report Server\ReportServer.web\
For example, C:\Syncfusion\Report Server\ReportServer.web\
We have shipped a utility with the Syncfusion Report Server application in the below location.
{Windows_Drive}\Syncfusion\Report Server\Utilities\DatabaseUninstaller
Figure 1: DatabaseUninstaller installed location
Follow the instructions below to remove resources and drop the database of the Report Server
Step 1: Stop the Report Server from the Desktop shortcut – “Stop Syncfusion Report Server”
Figure 2: Stop Syncfusion Report Server
Step 2: Open command prompt in administrator mode and navigate to the DatabaseUninstaller tool installed location.
Figure 3: Open command window for DatabaseUninstaller
{Installed_location}\Syncfusion\Report Server\Utilities\DatabaseUninstaller
Step 3: Type “databaseuninstaller reportserver” to remove resources and drop the database
Figure 4: Removing resources and dropping the database
The tool will remove the resources and drop the database and will return a “success” message if the process underwent successfully.
If there is an error occurred in the process, the tool will generate an error log in text format in the below location and display the error log file name.
Error log file location: %temp%/Syncfusion Report Server/{file_name}
Please create a support incident attaching this error log file for us to check the issue and give a solution.