[FIX] Reporting Service Catalog Database File Existence Failed

Installation of MS SQL Server is easy but if the error is coming simultaneously, it becomes one of a headache. And today we are also going to see such kind of error; "Reporting service catalog database file existence failed" and the way to get rid of that. Most of the time when we uninstall SQL server 2012 management studio or any version of MS SQL server, some of the files gets left behind that includes reporting services catalogs. If you too just like lots of users are searching about; reporting service catalog database file existence failed SQL server, reporting services catalog temporary database file existence, reporting services catalog database file existence SQL 2008 r2 failed, SQL server 2008 r2 reporting services catalog database file existence, reporting services catalog database file existence failed 2012, reporting services catalog database file existence failed 2014, rule reporting services catalog database file existence failed SQL 2012, reporting service catalog database file existence error, then you are on right page. Learn how to get rid of reporting service catalog database file existence failed.

Fix Reporting Service Catalog Database File Existence Failed

Last time we have seen how to fix Microsoft SQL Server Failed to Install or Reinstall | Repair & Install SQL Database. And today in continuing that, we are going to solve one of the critical error occurred in SQL reinstallation.

Also check: 5 Ways How Wearable Technology Will Improve Our Daily Life

Solved Reporting Service Catalog Database File Existence Failed

As you already installed MS SQL server before, therefore, the database is already been there and which is not get removed. And in this case, if you going for reinstallation, the integrated security SQL server will try to install SQL database with the same name. And hence you got the error; "Reporting Service Catalog Database File Existence Failed"

1. Go to
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
or
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQL2012\MSSQL\DATA
or
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

2. Delete following files;
ReportServer$MSSQL2012.mdf
ReportServer$MSSQL2012_log.mdf
ReportServer$MSSQL2012TempDB.mdf
ReportServer$MSSQL2012TempDB_log.mdf


3. Check it again.

Hope this will solve your issue. If you know any better way then we would like to add it here if you share it via comments.

Share this

Share on FacebookPlus on Google+