You are currently offline, waiting for your internet to reconnect

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"

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.
"SQL Server 2008 Reporting Services" SQL2008RelNoteReportingServices
Properties

Article ID: 956095 - Last Review: 03/19/2009 22:35:36 - Revision: 2.0

Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Standard

  • sql2008relnotereportingservices sql2008relnote kbexpertiseadvanced kbtshoot kbprb KB956095
Feedback
c=""> var varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("