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 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.

Related Articles

How to take MSSQL database offline or bring it online?

Sometimes, you come across to a situations when you are required to physically move the database...

How do I connect to MSSQL Server 2012 from SQL Server Management Studio?

This article will guide you on how to connect to MS SQL Server 2012 from SQL Server Management...

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

vs shell installation has failed with exit code 1638.

You may receive the following error while installing MSSQL 2017 on Windows 2012 R2 Server VPS or...

How to Restore SQL Server 2012 Database Backup to SQL Server 2008?

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if...

  • 0 Users Found This Useful

Was this answer helpful?