How to fix “Reporting Services Catalog Database File Existence” error while installing SQL Server?

You may receive the below error while installing the SQL server on your windows system. This error can occur if you have uninstalled your previous SQL version and installing a new SQL server on your system.

sql-config-error

If you click on the failed button, you will see the below 2 texts.

Rule “Reporting Services Catalog Database File Existence” failed.
The Reporting Services catalog database file exists. Select a Reporting Services files-only mode installation.
 
AND
 

Rule “Reporting Services Catalog Temporary Database File Existence” failed.
The Reporting Services catalog temporary database file exists. Select a Reporting Services files-only mode installation.

Click on the View Detailed Report and search for the RS_DoesCatalogExist, and it will indicate that the files of the previous installer are still there and it is causing the issue.

To fix this issue, open the location C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA (Depending on the SQL version, your Data file may have another location) and remove the files after taking the backup of it.

reporting-service

After removing the file, click the Re-run button, and the error will be removed as per the below screen.

rerun-installation

Finally, click on the install button to complete your installation.



Was this answer helpful?

« Back

chat