Friday, 28 December 2012

Reporting Services Catalog Database File Existence Failed


While installing the Microsoft SQL server 2008 enterprise evaluation edition I got an error as
“Reporting Services Catalog Database File Existence Failed or Temporary Database File Existence failed” as follows


Tried to google around to see if I get any solution on this and found the reason behind the error , It was mainly because someone earlier  had installed SQL server on this machine and that was uninstalled couple of days ago which had left some of its footprints on the machine through the reporting services files under program files

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA

This path showed some files created for reporting services, hence deleted those files (you need to have administrator privileges to delete them) and tried to Re-run the setup it went through with no errors as follows


Hence it worked for me the files deleted were found under C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA. Though I forgot to note down the filenames which i deleted , other blogs on the same issue tell you the name of the files also ; ReportServer.mdf,ReportServer_log.LDF,ReportServerTempDB.mdf,ReportServerTempDB_log.LDF etc . But yes it was indeed a learning experience.




No comments:

Post a Comment