Wednesday, June 20, 2012

ERROR : reporting services catalog database file existence while installing SQL server 2008 R2

SQL Server 2008 R2 Setup shows the following error messages after running a set of rules to determine if the installation process wizard Pre-requisites check.
  •  "Reporting Services Catalog Database File Existence" failed
  • "Reporting Services Catalog Temporary Database File Existence" failed.
Error message when you install a SQL Server 2008 Reporting Services instance by using an instance name that you previously uninstalled: "The catalog database file exists"

CAUSE :

This issue occurs because the databases for the SQL Server 2008 Reporting Services instance that you want to install already exist on the computer with following path.

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA


RESOLUTION :

Solution 1:

Use a different SQL instance name.

Solution 2:

Manually Remove .MDF and .LDF files from below path and Re-run Setup.
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA



Cheers!!!

Gaurang Patel
free spam filterexchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter

2 comments: