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