locked
SQL Server 2008 Install failure - Reporting Services Rule Failures RRS feed

  • 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

    Thursday, August 19, 2010 3:32 AM

Answers

  • 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
    • Marked as answer by TonyTony14 Wednesday, August 25, 2010 8:44 PM
    Friday, August 20, 2010 7:18 AM

All replies

  • 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
    • Marked as answer by TonyTony14 Wednesday, August 25, 2010 8:44 PM
    Friday, August 20, 2010 7:18 AM
  • 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

    Wednesday, August 25, 2010 8:44 PM
  • Thanks for your!! It really works!

    Thursday, August 2, 2012 1:18 AM
  • 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.

    Wednesday, January 30, 2019 10:50 AM