SQL Server 2012 安装 Reporting Services 目录错误

SQL Server 2012 installation Reporting Services Catalog error

提问by Humza Khan

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

我现在正在安装 SQL Server 2012，当我准备运行安装时，会弹出这个错误：

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

单击第一个失败的测试，即“报告服务目录数据库文件存在”，这就是我得到的：

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

单击第二个失败的测试，即“报告服务目录临时数据库文件存在”，这就是我得到的：

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.

所以基本上，两个消息框都告诉我“目录数据库文件”和“目录临时数据库文件存在”。因此，我需要选择 Reporting Services 仅文件模式安装。

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?

1. 如何选择仅文件模式安装？
2. 我是否必须关闭设置并执行某些操作，然后再次运行设置？

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. :)

顺便说一句，我之前安装了 SQL Server 2012。由于一些奇怪的错误，我完全卸载了它，并决定重新安装 SQL Server 2012 的新副本，现在我遇到了这些错误。任何帮助将不胜感激。:)

回答by KrazzyNefarious

Since you already had one installation of SQL Server done before, there was a database already created. That did notget 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.

由于您之前已经安装了一个 SQL Server，因此已经创建了一个数据库。那没有被删除。因此，当您重新安装时，它会尝试创建具有相同名称的数据库，因此会出现错误。您需要删除旧文件才能继续新安装。

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

从目录

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

删除以下文件

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

Try the Following link for further help.

尝试以下链接以获得进一步帮助。

Reporting Services Catalog Error.

Reporting Services 目录错误。

---

---

For sql-server-2012the path is:

对于sql-server-2012，路径是：

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

where MSSQL2012is the instance name and the respective file names are:

MSSQL2012实例名称在哪里，各自的文件名是：

• ReportServer$MSSQL2012.mdf
• ReportServer$MSSQL2012_log.mdf
• ReportServer$MSSQL2012TempDB.mdf
• ReportServer$MSSQL2012TempDB_log.mdf

• ReportServer$MSSQL2012.mdf
• ReportServer$MSSQL2012_log.mdf
• ReportServer$MSSQL2012TempDB.mdf
• ReportServer$MSSQL2012TempDB_log.mdf

回答by omar

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

从C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA目录中删除以下文件：

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

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

如果您重新安装 SQL Server 并且这些文件没有被删除，就会发生这种情况。