로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼
Resources for IT Professionals >
> 
> 
SQL server R2 SP1 install failed on SQL_FullText_Adv

답변됨 SQL server R2 SP1 install failed on SQL_FullText_Adv

  • 2012년 4월 17일 화요일 오전 1:37
     
     
    로그인하여 투표
    0

    Hello,

    My company has a server with windows 2008R2 server and SQL server 2008R2 installed (both enterprice version). While I am applying  SQL server R2 SP1, I got error  with "SQL_FullText_Adv". I did repare as suggested on this site, but the repaire failed again with errro "The SQL Server feature 'SQL_FullText_Adv' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature....... ", see detail below.

    Can please some share a light? Many thanks,

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2068578302
      Exit facility code:            1204
      Exit error code:               2
      Exit message:                  Failed: see details below
      Start time:                    2012-04-16 17:15:14
      End time:                      2012-04-16 17:53:56
      Requested action:              Repair
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120416_170402\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0x2841E06E%401204%402

    Machine Properties:
      Machine name:                 

      Machine processor count:       24
      OS version:                    Windows Server 2008 R2
      OS service pack:               Service Pack 1
      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
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No       
      Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Edition   10.50.1600.1    No       

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         E:\x64\setup\
      Installation edition:          ENTERPRISE

    User Input Settings:
      ACTION:                        Repair
      AGTDOMAINGROUP:                <empty>
      AGTSVCACCOUNT:                
      AGTSVCPASSWORD:               
      AGTSVCSTARTUPTYPE:             Automatic
      ASCONFIGDIR:                   Config
      ASDOMAINGROUP:                 <empty>
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120416_170402\ConfigurationFile.ini
      ENU:                           True
      FAILOVERCLUSTERGROUP:          <empty>
      FAILOVERCLUSTERNETWORKNAME:    <empty>
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
      FTSVCPASSWORD:                 *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      PASSPHRASE:                    *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      SQLDOMAINGROUP:                <empty>
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                *****
      UIMODE:                        Normal
      X86:                           False

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Client Connectivity
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Writer
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Browser
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Full-Text Search
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      

      Configuration error description: The SQL Server feature 'SQL_FullText_Adv' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120416_170402\Detail.txt
      Configuration status:          Failed: see details below
      Configuration error code:      0x2841E06E@1204@2
      Configuration error description: The SQL Server feature 'SQL_FullText_Adv' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120416_170402\Detail.txt

      Feature:                       Analysis Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Reporting Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Integration Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Compact Edition Tools
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Compact Edition Runtime
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Client Tools Connectivity
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Complete
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Business Intelligence Development Studio
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Books Online
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Microsoft Sync Framework
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

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

    The following warnings were encountered while configuring settings on your SQL Server.  These resources / settings were missing or invalid so default values were used in recreating the missing resources.  Please review to make sure they don’t require further customization for your applications:

    Service SID support has been enabled on the service.
    Service SID support has been enabled on the service.


    • 편집됨 SQLqI 2012년 4월 17일 화요일 오전 1:50
    •  
     

모든 응답

  • 2012년 4월 17일 화요일 오전 2:04
    중재자
     
     
    로그인하여 투표
    0
    One solution will be uninstall the fulltext feature then install just this feature back.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

     
  • 2012년 4월 17일 화요일 오전 2:22
     
     
    로그인하여 투표
    0

    Thanks Ahmed,

    Good idea, but I never did uninstall FullText before, should I uninstall from add/remove feature or from SQL SERVER 2008R2 setup?

     
  • 2012년 4월 17일 화요일 오전 2:27
    중재자
     
     
    로그인하여 투표
    0
    Yes.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

     
  • 2012년 4월 17일 화요일 오전 2:38
     
     
    로그인하여 투표
    0

    I just checked the server which has both SQL Full-Text filter Deamon Launcher and SQL server browser running. Should I uninstall both of them or just sql server browser?

    Thanks,

     
  • 2012년 4월 17일 화요일 오전 2:45
    중재자
     
     
    로그인하여 투표
    0
    Per summary log the only Fulltext failed so you need to re install it , I don't think you need to uninstall browser.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

     
  • 2012년 4월 17일 화요일 오전 2:52
     
     
    로그인하여 투표
    0

    I couldn't find the full-text feature in either add/uninstall program or SQL server installation center, can you please tell me where I can find this feature?

    Thanks,


    • 편집됨 SQLqI 2012년 4월 17일 화요일 오전 2:53
    •  
     
  • 2012년 4월 17일 화요일 오전 3:03
    중재자
     
     답변됨
    로그인하여 투표
    0

    http://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature

    you can run command line install

    setup.exe /Action=Install /Features=FullText

    Just make sure that the media you are running from support fulltext installation

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    • 답변으로 표시됨 SQLqI 2012년 4월 17일 화요일 오후 4:57
    •  
     
  • 2012년 4월 17일 화요일 오전 3:34
     
     
    로그인하여 투표
    0

    OK, I read the link you gave to me. I think it's pretty clear that I cannot just remove one of SQL Server instance features, I have unstall the SQL server instance. I think I need to think about it since we have 20 DBs running on it and it also intergrated with Sharepoint.  I'll let you know the results.

    Thanks a lot


    • 편집됨 SQLqI 2012년 4월 17일 화요일 오전 3:40
    •  
     
  • 2012년 4월 17일 화요일 오전 4:19
    중재자
     
     
    로그인하여 투표
    0
    No, you can it is just possible to run setup.exe /Action=Uninstall /Features =FullText

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

     
  • 2012년 4월 17일 화요일 오전 11:56
     
     답변됨
    로그인하여 투표
    0

    Hi,

    As Ahmed is saying, you can do it this way. But when getting messages like "Only features from successful installations can be repaired" you can try to reset the registry values in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance>\ConfigurationState

    I have encountered a similar problem when upgrading to SP1 on SQL2008R2 and I had to clear a registry setting before I could continiue to install the update.

    Hopes this helps you, please say how it works out!

    • 답변으로 표시됨 SQLqI 2012년 4월 17일 화요일 오후 4:57
    •  
     
  • 2012년 4월 17일 화요일 오후 4:56
     
     
    로그인하여 투표
    0

    I ended up to reset the register value. And then SP1 installed smoothly without any problem.

    Many many thanks to both of you for great advices.