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"

Article translations Article translations
Article ID: 956095 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You try to install a Microsoft SQL Server 2008 Reporting Services instance by using an instance name that you previously uninstalled from the computer. When you do this, you may receive one of the following error messages:
The catalog database file exists. Select a files-only mode installation.
The catalog temporary database file exists. Select a files-only mode installation.

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.

RESOLUTION

To resolve this issue, move, rename, or delete the existing Report Server databases. Or, use a different instance name.

MORE INFORMATION

By default, when you install an instance of SQL Server 2008 Reporting Services, the instance setup process creates two new databases that are named "ReportServer_Instance_Name" and "ReportServer_Instance_nameTempDB." These databases are created under the following folder for the instance of the SQL Server that you are running:
%ProgramFiles%\Microsoft SQL Server\MSSQL10.Instance Name\MSSQL\DATA
Note For the default MSSQLSERVER instance, the database names are "ReportServer" and "ReportServerTempDB."

These databases may contain user data. Therefore, the Setup program does not delete these databases when you uninstall a SQL Server 2008 Reporting Services instance. When you install an instance that has the same instance name, the Setup program detects that the Report Server databases already exist for that instance name. When this occurs, you receive the error message that is mentioned in the "Symptoms" section.

Properties

Article ID: 956095 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
Keywords: 
sql2008relnotereportingservices sql2008relnote kbexpertiseadvanced kbtshoot kbprb KB956095

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com