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

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

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 (Depends on SQL version, your Data file may have another location) and remove the files after taking the backup of it.

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

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