Quote

"Between stimulus and response there is a space. In that space is our power to choose our response.
In our response lies our growth and freedom"


“The only way to discover the limits of the possible is to go beyond them into the impossible.”


Wednesday 15 April 2015

Reporting Services Temporary Database File Existence Error in SQLServer 2012

This error appears only when a machine is being used for re-installation of MSSQLSERVER after improper uninstall. This happens even after a successful uninstall using the UI un-installer budled with mssqlserver. As a result of prior installation of SQL Server a temp database is already created which does not get deleted after uninstall. If we try to reinstall using same instance name the following error is returned:

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


To get past this error go to installation location typically the location is as follows:
C:\Program Files\Microsoft SQL Server
C:\Program Files (x86)\Microsoft SQL Server

Remove existing files from this location and re-run the rules validation. You will notice that reporting validation errors are green.
The issue is because of these files being present:

ReportServer.mdf
bulletReportServer_log.LDF
bulletReportServerTempDB.mdf
bulletReportServerTempDB_log.LDF


Once these are removed, installer validations are successful.  

No comments:

Post a Comment