SQL Server 2012 installation Reporting Services Catalog error

Solution 1:

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

Solution 2:

Remove the following files from the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA directory:

bulletReportServer.mdf
bulletReportServer_log.LDF
bulletReportServerTempDB.mdf
bulletReportServerTempDB_log.LDF.

This happens if you reinstall SQL Server and these files weren't deleted.