locked
SQL não inicia a instalação RRS feed

  • Pergunta

  • Srs.

    Preciso muito de ajuda.

    Tenho um servidor com Windows 2008 instalado com todas as atualizações e com SQL Server 2008 Express instalado com SP1.

    Estou tentando atualizar com SQL Server 2008 Standard, entretanto, após a seleção dos módulos que desejo instalar, o SQL apresenta aquele quadradinho azul de "Aguarde" e não avança. Sou obrigado o Gerenciador de Tarefas para encerar o programa.

    Alguém tem uma dica?

    segunda-feira, 20 de maio de 2013 19:59

Respostas

Todas as Respostas

  • Olá Mauricio!

    A instalação do SQL Server a partir da versão 2005 gera um log chamado Bootstrap Log, estes logs se você nao mudou o diretorio da instalação vão estar nos caminhos abaixo:

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\

    Cole aqui o que você ve no Summary.txt. Para investigarmos melhor o motivo do congelamento.

    Obrigado!


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    terça-feira, 21 de maio de 2013 00:15
  • Obrigado pela pronta resposta.

    Segue o log:

    Overall summary:
      Final result:                  User cancelled
      Exit code (Decimal):           -2068380094
      Exit facility code:            1207
      Exit error code:               1602
      Exit message:                  User has cancelled.
      Start time:                    2013-05-21 13:13:59
      End time:                      2013-05-21 13:16:25
      Requested action:              Install

    Machine Properties:
      Machine name:                  PUCK280
      Machine processor count:       8
      OS version:                    Windows Server 2008
      OS service pack:               Service Pack 1
      OS region:                     Brasil
      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 2005      MSSQLSERVER          MSSQL.1                        Database Engine Services                 1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SQL Server Replication                   1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SharedTools                              1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          Tools                                    1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          ToolsClient                              1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Express Edition      9.2.3042        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:\My Program Files\temp\x64\setup\
      Installation edition:          ENTERPRISE

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             
      CUSOURCE:                      
      ENABLERANU:                    False
      ERRORREPORTING:                False
      FEATURES:                      SQLENGINE,REPLICATION,CONN,IS,BC,BOL,SSMS,ADV_SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PCUSOURCE:                     
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      X86:                           False

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Integration Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Client Tools Connectivity
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Books Online
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

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

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
        Message: 
            User has cancelled.
        Stack: 
            at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
            at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
            at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

    terça-feira, 21 de maio de 2013 16:18
  • Mauricio,

    Acredito que teremos que o olhar o detail.txt referente a data e horario que você tentou instalar a ultima vez.

    Poderia providenciar?

    O details.txt estara dentro de uma pasta parecida com a abaixo:

    20121217_155529 - Instalação executada no dia 17 de dezembro de 2012 as 15h55.

    Obrigado!


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br


    terça-feira, 21 de maio de 2013 19:07
  • Obrigado a você.

    É um arquivo grande, vou ter que dividir!

    Essa é a parte final:

    2013-05-21 13:15:05 Slp: Completed Action: SetMultiInstanceTransformAction, returned True
    2013-05-21 13:15:05 Slp: ----------------------------------------------------------------------
    2013-05-21 13:15:05 Slp: Running Action: AddInstallModificationModifiersAction
    2013-05-21 13:15:05 Slp: Error: Action "AddInstallModificationModifiersAction" threw an exception during execution.
    2013-05-21 13:15:05 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Method not found: 'Boolean Microsoft.SqlServer.Configuration.MsiExtension.MsiExtensionMetadata.get_IsSlipstreamOrPatch()'. ---> System.MissingMethodException: Method not found: 'Boolean Microsoft.SqlServer.Configuration.MsiExtension.MsiExtensionMetadata.get_IsSlipstreamOrPatch()'.
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.AddInstallModificationModifiersAction.ExecuteAction(String actionId)
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2013-05-21 13:15:05 Slp:    --- End of inner exception stack trace ---
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2013-05-21 13:15:05 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    2013-05-21 13:16:24 Slp: Received cancel request from user, skipping remaining scheduled actions
    2013-05-21 13:16:24 Slp: Error: Action "GatherUserSettings" threw an exception during execution.
    2013-05-21 13:16:24 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: User has cancelled. ---> Microsoft.SqlServer.Chainer.Infrastructure.CancelException: User has cancelled.
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2013-05-21 13:16:24 Slp:    --- End of inner exception stack trace ---
    2013-05-21 13:16:24 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2013-05-21 13:16:25 Slp: Received request to add the following file to Watson reporting: C:\Users\Administrator\AppData\Local\Temp\2\tmpA401.tmp
    2013-05-21 13:16:25 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2013-05-21 13:16:25 Slp: Inner exceptions are being indented
    2013-05-21 13:16:25 Slp: 
    2013-05-21 13:16:25 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
    2013-05-21 13:16:25 Slp:     Message: 
    2013-05-21 13:16:25 Slp:         User has cancelled.
    2013-05-21 13:16:25 Slp:     Stack: 
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2013-05-21 13:16:25 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)


    quarta-feira, 22 de maio de 2013 00:30
  • Mauricio,

    Tenho algumas sugestões:

    1 - Tentar instalar com uma conta de usuário diferente, admin local do windows.

    2 - Tentar atualizar já fazendo o "slipstream" com o ultimo service pack lançado. Procedimento no link abaixo:

    http://support.microsoft.com/kb/955392

    3 - Se nenhuma das alternativas acima funcionar, acredito que o melhor seja desinstalar a versão atual, limpar as chaves no registry e tentar novamente.

    Um abraço!


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br


    quarta-feira, 22 de maio de 2013 01:06
  • Entendi a sugestão do "slipstream", entretanto o problema não está na versão que tento instalar pois em outros computadores ela funciona perfeitamente. O problema parece residir na instalação do atual servidor. Vou tentar algumas atualizações e caso não resolva, a solução será desinstalar a versão atual.

    Obrigado pela ajuda.

    quarta-feira, 22 de maio de 2013 01:38
  • Algumas falhas de setup acabam sendo sanadas via slipstream, faça os seus testes e de um retorno aqui depois! Até mais!


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Sugerido como Resposta fernando silva 1 quinta-feira, 23 de maio de 2013 14:40
    quarta-feira, 22 de maio de 2013 01:44
  • Consegui!

    O problema foi resolvido com a instalação do SQL Server 2008 SP3.

    Valeu.

    quinta-feira, 23 de maio de 2013 22:24
  • Opa que ótimo!

    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    sexta-feira, 24 de maio de 2013 13:13