SQL Server Reporting Services installation failure “The Reporting Service catalog database file exists.”

0
5650
sql vector image

Recently, I got the error below when re-installing Microsoft SQL Server 2016 Reporting Services on my server:

The catalog database file exists. Select a files-only mode installation.
The catalog temporary database file exists. Select a files-only mode installation.

sql reporting error

When clicking the first failed test, “Reporting Services Catalog Database File Existence”, I got the following detail:

sql reporting error detail

When clicking the second failed test, “Reporting Services Catalog Temporary Database File Existence”, I got the following detail:

sql reporting error detail

Resolution

This error occurs because there was a database already created on the previous installation that did not get removed. The solution is you need to remove the old database files to continue the new installation.

First, go to the folder where the SQL database created. Below is the default location of SQL Server Database:

SQL Server 2008: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
SQL Server 2012: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQL2012\MSSQL\DATA
SQL Server 2016: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL2012\MSSQL\DATA

You can also check the following link for the detail.

Then, on the SQL Database folder above, you need to remove the following files:

  • ReportServer.mdf
  • ReportServer_log.LDF
  • ReportServerTempDB.mdf
  • ReportServerTempDB_log.LDF

If you like this article, please share, subscribe or you can follow our Facebook Page and Twitter.

LEAVE A REPLY

Please enter your comment!
Please enter your name here