Thursday, February 9, 2012

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

Error :

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

Solution

Open the folder
"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA"
Delete the below files from the folder

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

After deleting the above files ,click Re-run in the setup window

7 comments:

  1. Very good instructions. The only changes was I had to open MSSQL11 but everyting else was the same. Thank You for the help.

    ReplyDelete
  2. when deleting, it says "the action can't be completed as it is open in SQL Server(MSSQLSERVER)

    ReplyDelete
  3. Thank you very much

    ReplyDelete
  4. worked i had to check all MSSQL10.MSSQLSERVER
    MSSQL11.MSSQLSERVER

    ReplyDelete
  5. I had to check all the MSSQL10.MSSQLSERVER\MSSQL files to find the targeted files yeas it worked

    ReplyDelete