SQL server 2014 installation error

Question

SQL server 2014 installation error

Asked 7 years, 8 months ago

Viewed 3,303 times

-1

Good evening guys! I am trying to install sql server 2014 express, but at the time of installation the following errors happen, what might be? Thank you

LOG
The error log is this. I’m sorry if you have another way to send this error, I don’t know how you do it.

Overall summary:
  Final result:                  Falha: consulte os detalhes abaixo
  Exit code (Decimal):           -2061893607
  Start time:                    2016-11-05 11:23:00
  End time:                      2016-11-05 11:32:14
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente.
  Next step for Replication:     Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente.


Machine Properties:
  Machine name:                  STUDIONE-PC
  Machine processor count:       4
  OS version:                    Windows 8
  OS service pack:               
  OS region:                     Brasil
  OS language:                   Português (Brasil)
  OS architecture:               x64
  Process architecture:          64 Bits
  OS clustered:                  Não

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
  SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Serviços de Mecanismo de Banco de Dados  1033                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Serviços de Mecanismo de Banco de Dados  1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Replicação do SQL Server                 1033                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Replicação do SQL Server                 1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          Ferramentas de Geranciamento - Básicas   1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          Ferramentas de Gerenciamento - Completas 1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          Conectividade das Ferramentas de Cliente 1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          Compatibilidade das Ferramentas de Cliente com Versões Anteriores 1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          SDK de Ferramentas de Cliente            1046                 Express Edition      12.1.4100.1     Não        Sim       
  SQL Server 2014                                                          LocalDB                                  1046                 Express Edition      12.1.4100.1     Não        Sim       

Package properties:
  Description:                   Microsoft SQL Server 2014 
  ProductName:                   SQL Server 2014
  Type:                          RTM
  Version:                       12
  Installation location:         C:\Users\StudiOne\Downloads\pt_sql_server_2014_express_with_tools_with_service_pack_1_x64_6674722\x64\setup\
  Installation edition:          Express

  Slipstream:                    True
  SP Level                       1

Product Update Status:
  Êxito: KB 3058865

Product Updates Selected for Installation:
  Title:                         Microsoft SQL Server 2014  Express with Tools SP1
  Knowledge Based Article:       KB 3058865
  Version:                       12.1.4100.0
  Architecture:                  x64
  Language:                      1046

  Update Source:                 Slipstream


Configurações de Entrada do Usuário:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      true
  AGTSVCACCOUNT:                 AUTORIDADE NT\SERVIÇO DE REDE
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Disabled
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  MULTIDIMENSIONAL
  ASSVCACCOUNT:                  <vazio>
  ASSVCPASSWORD:                 <vazio>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <vazio>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   <vazio>
  CLTRESULTDIR:                  <vazio>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <vazio>
  CLTSVCPASSWORD:                <vazio>
  CLTWORKINGDIR:                 <vazio>
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <vazio>
  CTLRSVCPASSWORD:               <vazio>
  CTLRUSERS:                     <vazio>
  ENABLERANU:                    true
  ENU:                           false
  ERRORREPORTING:                false
  FEATURES:                      SQLENGINE, REPLICATION
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <vazio>
  FTSVCACCOUNT:                  <vazio>
  FTSVCPASSWORD:                 <vazio>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  true
  INDICATEPROGRESS:              false
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <vazio>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    SQLEXPRESS
  INSTANCENAME:                  SQLEXPRESS
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <vazio>
  ISSVCSTARTUPTYPE:              Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <vazio>
  MATRIXNAME:                    <vazio>
  NPENABLED:                     0
  PID:                           *****
  QUIET:                         false
  QUIETSIMPLE:                   false
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 DefaultNativeMode
  RSSHPINSTALLMODE:              DefaultSharePointMode
  RSSVCACCOUNT:                  <vazio>
  RSSVCPASSWORD:                 <vazio>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         <vazio>
  SECURITYMODE:                  <vazio>
  SQLBACKUPDIR:                  <vazio>
  SQLCOLLATION:                  Latin1_General_CI_AS
  SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS
  SQLSVCPASSWORD:                <vazio>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           StudiOne-PC\StudiOne
  SQLTEMPDBDIR:                  <vazio>
  SQLTEMPDBLOGDIR:               <vazio>
  SQLUSERDBDIR:                  <vazio>
  SQLUSERDBLOGDIR:               <vazio>
  SQMREPORTING:                  false
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  UpdateEnabled:                 true
  UpdateSource:                  Slipstream
  USEMICROSOFTUPDATE:            false
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20161105_112300\ConfigurationFile.ini

Detailed results:
  Feature:                       Serviços de Mecanismo de Banco de Dados
  Status:                        Falha: consulte os logs para obter detalhes
 Reason for failure:            Erro durante o processo de instalação do recurso.
  Next Step:                     Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente.
  Component name:                Recursos de Instância dos Serviços do Mecanismo de Banco de Dados do SQL Server
  Component error code:          0x851A0019
  Error description:             Não foi possível encontrar o identificador de inicialização do Mecanismo de Banco de Dados.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.4100.1&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025

  Feature:                       Replicação do SQL Server
  Status:                        Falha: consulte os logs para obter detalhes
  Reason for failure:            Um erro em uma dependência do recurso está ocasionando falha no processo de instalação do recurso.
  Next Step:                     Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente.
  Component name:                Recursos de Instância dos Serviços do Mecanismo de Banco de Dados do SQL Server
  Component error code:          0x851A0019
  Error description:             Não foi possível encontrar o identificador de inicialização do Mecanismo de Banco de Dados.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.4100.1&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20161105_112300\SystemConfigurationCheck_Report.htm

1

Post the log file that is specified in the highlighted path at the bottom of the screen.

– Sorack

2016/11/05 at 03:46
@Guilhermeramos, enabled . NET Framework 3.5 SP1, before starting the installation of SQL Server?

– José Diz

2016/11/05 at 19:16

1 answer

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.

by José Diz • **6,942** points · Answer 1 · 2016-11-05T19:10:52+00:00

Guilherme, what you are installing is SQL Server 2014 Express with SP1, SQLEXPRWT_X64 package. There is a more recent compilation, already with service pack 2: SQL Server 2014 Service Pack 2 (SP2) Express. But this is not the cause of installation error.

Before installing SQL Server, careful reading of the document is suggested Hardware and software requirements for installing SQL Server 2014, which contains what is necessary for a successful installation.

The log gives the information that the computer is running Windows 8, 64 bits, Portuguese language. In this case, before starting the installation of SQL Server it is necessary to enable . NET Framework 3.5, as stated in the component requirements: "If you run Installation on a computer with (...) Windows 8, you must enable . NET Framework 3.5 SP1 before installing SQL Server 2014".

Still with respect to the . NET Framework, there is the following remark: "If you are installing SQL Server Express editions, make sure an Internet connection is available on your computer. Install SQL Server download and install . NET Framework 4 because it is not included in SQL Server Express media".

If replication is not required, then I suggest you do not check this option on the installation. Express edition only acts as a subscriber (Subscriber), in replications. Details in Features compatible with SQL Server 2014 editions.