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
Posted by at
Labels:

7 comments:

  1. AnonymousAugust 1, 2012 at 6:16 AM

    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. BagavathiNovember 30, 2012 at 11:27 AM

    thanks a lot....

    ReplyDelete
  3. AnonymousMay 7, 2013 at 12:18 AM

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

    ReplyDelete
  4. AnonymousJuly 26, 2013 at 6:30 PM

    Thank you very much

    ReplyDelete
  5. UnknownMarch 25, 2014 at 9:04 AM

    perfect...Thanks

    ReplyDelete
  6. ufomexiledApril 6, 2014 at 4:11 AM

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

    ReplyDelete
  7. ufomexiledApril 6, 2014 at 4:14 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)