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 setup MSSQL database mirroring?

Following are the steps to set up database mirroring using certificate-based authentication. It...

How to change database language in MS SQL 2012 server?

Following article will guide you to change database language in MS SQL 2012 server. Login to...

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to upgrade SQL Enterprise Evaluation edition to SQL Developer edition?

If you have installed the MSSQL Evaluation edition, you can easily upgrade it to the Developer...

How to Create MS SQL Database Through SQL Server Management Studio?

This article will assist you to create MS SQL database through SQL Server Management Studio....

  • 0 Users Found This Useful

Was this answer helpful?