Thursday, November 04, 2010

Rule "Reporting Services Catalog Database File Existence" failed

Due to some reason i had to reinstall the SQL Server 2008 and when setup validates the installation it prompted for following 2 errors as below :

  • Rule "Reporting Services Catalog Database File Existence" failed
  • Rule "Reporting Services Catalog Temporary Database File Existence" failed.

clip_image004

so what you have to do is to delete following files

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

from the location : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA and re-run the setup.