MSSQL Install – “Reporting Services Catalog Database File Existence” failed

This happened to me because I installed MMSQL Server and then I had to uninstall it and re-install because I had the collation wrong. But during one of the pre-installation checks that SQL Server runs it come up with:

“Reporting Services Catalog Database File Existence” failed
“Reporting Services Catalog Temporary Database File Existence” failed.

reporting_services_catalog_database_failed

To fix this problem we need to delete some files that the SQL Server uninstaller must miss for some reason.

Navigate to “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA” then delete the following files:files_to_delete

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

Once you have deleted the files hit the re-run button on the pre-installation check and it will pass.

Now your problem should be resolved just continue on with your install.

Replies: 38 / Share:

You might also like …

Post Comment

Your email address will not be published. Required fields are marked *