SQL Server 2008 Install failure - Reporting Services Rule Failures

Question

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures:

Reporting Services Catalog Database File Existance
Reporting Services Catalog Temporary Database File Existance

Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation"

Clicking the "Help" button tells me to "Rename, move, or delete the files"

This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help.

Thank you so much for any help.

Select Log Files:

SUMMARY GLOBAL RULES LOG:

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2010-08-17 19:13:40
  End time:                      2010-08-17 19:14:10
  Requested action:              RunRules

Machine Properties:
  Machine name:                  TONY-PC
  Machine processor count:       8
  OS version:                    Windows Vista
  OS service pack:              
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

Package properties:
  Description:                   SQL Server Database Services 2008
  SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
  ProductName:                   SQL2008
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\x64\setup\
  Installation edition:          EVAL

User Input Settings:
  ACTION:                        RunRules
  CONFIGURATIONFILE:            
  FEATURES:                     
  HELP:                          False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  <empty>
  MEDIASOURCE:                   D:\
  QUIET:                         False
  QUIETSIMPLE:                   False
  RULES:                         GlobalRules
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100817_191339\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100817_191339\SystemConfigurationCheck_Report.htm

SUMMARY COMPONENT UPDATE LOG:

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2010-08-17 19:14:12
  End time:                      2010-08-17 19:19:07
  Requested action:              ComponentUpdate

Machine Properties:
  Machine name:                  TONY-PC
  Machine processor count:       8
  OS version:                    Windows Vista
  OS service pack:              
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Package properties:
  Description:                   SQL Server Database Services 2008
  SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
  ProductName:                   SQL2008
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\x64\setup\
  Installation edition:          DEVELOPER

User Input Settings:
  ACTION:                        ComponentUpdate
  CONFIGURATIONFILE:            
  HELP:                          False
  INDICATEPROGRESS:              False
  MEDIASOURCE:                   D:\
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100817_191339\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100817_191339\SystemConfigurationCheck_Report.htm

Answer 1

Hi TonyTony14,

 

Since you have failed on these two rules: “porting Services Catalog Database File Existance” and “Reporting Services Catalog Temporary Database File Existance”, this issue might be caused by that the previous installation of SQL Server Reporting Service (SSRS) has not been removed completely.

 

In the situation that the previous installation of SSRS has not been removed completely, please locate to this folder: "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA", then copy following files to another folder and remove the original files:

ReportServer.mdf

ReportServer_log.LDF

ReportServerTempDB,mdf

ReportServerTempDB_log.LDF

 

If anything is unclear, please let me know.

---

Regards,
Tom Li

Answer 2

Hi Tom,

Thank you so much.  This worked perfectly.  I haven't installed yet but it got me past the Installation Rules section.

Very much appreciated!

Tony

Answer 3

Thanks for your!! It really works!

Answer 4

Hi Tom,

Any assistance on this one?

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2019-01-30 09:55:50
  End time:                      2019-01-30 09:56:43
  Requested action:              LandingPage

Machine Properties:
  Machine name:                 BI
  Machine processor count:       2
  OS version:                    Microsoft Windows Server 2012 R2 Standard (6.3.9600)
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Package properties:
  Description:                   Microsoft SQL Server 2016 
  ProductName:                   SQL Server 2016
  Type:                          RTM
  Version:                       13
  SPLevel:                       0
  Installation location:         C:\Users\Administrator\Desktop\Set ups\sql\x64\setup\
  Installation edition:          

User Input Settings:
  ACTION:                        LandingPage
  CONFIGURATIONFILE:             
  ENU:                           true
  HELP:                          false
  IACCEPTROPENLICENSETERMS:      false
  INDICATEPROGRESS:              false
  MRCACHEDIRECTORY:              
  QUIET:                         false
  QUIETSIMPLE:                   false
  SUPPRESSPRIVACYSTATEMENTNOTICE: false
  UIMODE:                        Normal
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20190130_095550\ConfigurationFile.ini

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               The rule result report file is not available.