Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server 2012 installation Reporting Services Catalog error

I'm installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up:

The errors can be seen clearly in this picture

On clicking the first failed test, which is "Reporting Services Catalog Database File Existence", this is what i get:

enter image description here

On clicking the second failed test, which is "Reporting Services Catalog Temporary Database File Existence", this is what i get:

enter image description here

So basically, both of the message box says me that "Catalog Database File" & "Catalog Temporary database files exists". Because of this, i need to select Reporting Services file-only mode installation.

My questions are:

  1. How do i select file-only mode installation?
  2. Do i've to close the setup and do something and afterwards run the setup again?

Btw, I had SQL Server 2012 installed before. I uninstalled it completely due to some strange errors and decided to reinstall a fresh copy of SQL Server 2012 and now I'm stuck with these errors. Any help will be sincerely appreciated. :)

like image 381
Humza Khan Avatar asked May 08 '14 20:05

Humza Khan


People also ask

How do I fix a SQL Server installation error?

Launch the SQL Server Setup program (setup.exe) from SQL Server installation media. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.

How do I remove Reporting Services catalog database file exists?

To fix this issue, open the location C:\Program Files\Microsoft SQL Server\MSSQL13. MSSQLSERVER\MSSQL\DATA (Depends on SQL version, your Data file may have another location) and remove the files after taking the backup of it.

How do I disable SQL Server error and reporting?

To disable Error or Feature Usage reporting for all instances of SQL Server and its components after Setup completes, go to the Error and Usage Report Settings dialog and clear the check boxes for Feature Usage.


1 Answers

Since you already had one installation of SQL Server done before, there was a database already created. That did not get removed. So when you reinstall, its trying to create the database with the same name, hence, the error. You need to delete the old files to continue the new installation.

From the direcotry

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

Remove the following files

  • ReportServer.mdf
  • ReportServer_log.LDF
  • ReportServerTempDB.mdf
  • ReportServerTempDB_log.LDF

Screenshot

Try the Following link for further help.

Reporting Services Catalog Error.


For sql-server-2012 the path is:

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQL2012\MSSQL\DATA 

where MSSQL2012 is the instance name and the respective file names are:

  • ReportServer$MSSQL2012.mdf
  • ReportServer$MSSQL2012_log.mdf
  • ReportServer$MSSQL2012TempDB.mdf
  • ReportServer$MSSQL2012TempDB_log.mdf
like image 149
KrazzyNefarious Avatar answered Sep 25 '22 03:09

KrazzyNefarious