Usuário com melhor resposta
SQL não inicia a instalação

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
-
Consegui!
O problema foi resolvido com a instalação do SQL Server 2008 SP3.
Valeu.
- Marcado como Resposta Junior Galvão - MVPMVP, Moderator segunda-feira, 23 de dezembro de 2019 01:04
quinta-feira, 23 de maio de 2013 22:24
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
- Editado André César RodriguesMicrosoft employee terça-feira, 21 de maio de 2013 19:07
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)
- Editado Mauricio Arêas quarta-feira, 22 de maio de 2013 00:32
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
- Editado André César RodriguesMicrosoft employee quarta-feira, 22 de maio de 2013 01:07
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.
- Marcado como Resposta Junior Galvão - MVPMVP, Moderator segunda-feira, 23 de dezembro de 2019 01:04
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