none
error instalando sql express 2014 RRS feed

  • Debate general

  • hola,

    ¿alguien me puede ayudar con este error instalando sql server 2014?

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2061893606
      Start time:                    2016-11-11 06:56:07
      End time:                      2016-11-11 07:04:45
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Next step for Replication:     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


    Machine Properties:
      Machine name:                  WINDOWS-UMNHGU2
      Machine processor count:       8
      OS version:                    Windows 8
      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  Configured
      SQL Server 2014                                                          Management Tools - Basic                 1033                 Express Edition      12.0.2000.8     No         Yes       
      SQL Server 2014                                                          Management Tools - Complete              1033                 Express Edition      12.0.2000.8     No         Yes       
      SQL Server 2014                                                          Client Tools Connectivity                1033                 Express Edition      12.0.2000.8     No         Yes       
      SQL Server 2014                                                          Client Tools Backwards Compatibility     1033                 Express Edition      12.0.2000.8     No         Yes       
      SQL Server 2014                                                          Client Tools SDK                         1033                 Express Edition      12.0.2000.8     No         Yes       

    Package properties:
      Description:                   Microsoft SQL Server 2014 
      ProductName:                   SQL Server 2014
      Type:                          RTM
      Version:                       12
      SPLevel:                       0
      Installation location:         C:\Users\becavas\Downloads\SQLEXPR_x64_ENU (1)\x64\setup\
      Installation edition:          Express

    Product Update Status:
      None discovered.

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      true
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   <empty>
      CLTRESULTDIR:                  <empty>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <empty>
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 <empty>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    true
      ENU:                           true
      ERRORREPORTING:                false
      FEATURES:                      SQLENGINE, REPLICATION
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTSQLSERVERLICENSETERMS:  true
      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:                    SQLEXPRESS
      INSTANCENAME:                  SQLEXPRESS
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  Modern_Spanish_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           WINDOWS-UMNHGU2\becavas
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  false
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred during the setup process of the feature.
      Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       SQL Browser
      Status:                        Passed

      Feature:                       SQL Writer
      Status:                        Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

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


    desarrollador .NET

    viernes, 11 de noviembre de 2016 12:19

Todas las respuestas

  • Saludos

    De hecho parece que si los instalo pero no pudo levantar el servicio de SQL Server por x o y razón te pide que veas el errorlog.0 de tu sql server podrias verificar o si necesitas mas ayuda compartirlo.

    viernes, 11 de noviembre de 2016 20:10
  • Esto encontré  :

    2016-11-11 06:59:21.58 Server      Microsoft SQL Server 2014 - 12.0.2000.8 (X64) 
    Feb 20 2014 20:04:26 
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: )

    2016-11-11 06:59:21.58 Server      UTC adjustment: -5:00
    2016-11-11 06:59:21.58 Server      (c) Microsoft Corporation.
    2016-11-11 06:59:21.58 Server      All rights reserved.
    2016-11-11 06:59:21.58 Server      Server process ID is 14452.
    2016-11-11 06:59:21.58 Server      System Manufacturer: 'Alienware', System Model: 'Alienware 15 R2'.
    2016-11-11 06:59:21.58 Server      Authentication mode is MIXED.
    2016-11-11 06:59:21.58 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    2016-11-11 06:59:21.58 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
    2016-11-11 06:59:21.58 Server      Registry startup parameters: 
    -d C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    2016-11-11 06:59:21.58 Server      Command Line Startup Parameters:
    -s "SQLEXPRESS"
    -m "SqlSetup"
    -Q
    -q "Modern_Spanish_CI_AS"
    -T 4022
    -T 4010
    -T 3659
    -T 3610
    -T 8015
    -d "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\master.mdf"
    -l "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
    2016-11-11 06:59:21.77 Server      SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2016-11-11 06:59:21.77 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2016-11-11 06:59:21.77 Server      Detected 16283 MB of RAM. This is an informational message; no user action is required.
    2016-11-11 06:59:21.77 Server      Using conventional memory in the memory manager.
    2016-11-11 06:59:21.92 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
    2016-11-11 06:59:21.94 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2016-11-11 06:59:21.95 Server      Query Store settings initialized with enabled = 1, 
    2016-11-11 06:59:21.95 Server      The maximum number of dedicated administrator connections for this instance is '1'
    2016-11-11 06:59:21.96 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2016-11-11 06:59:21.96 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2016-11-11 06:59:21.99 Server      Database Mirroring Transport is disabled in the endpoint configuration.
    2016-11-11 06:59:21.99 Server      Software Usage Metrics is disabled.
    2016-11-11 06:59:21.99 spid7s      Warning ******************
    2016-11-11 06:59:21.99 spid7s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2016-11-11 06:59:21.99 spid7s      Starting up database 'master'.
    2016-11-11 06:59:22.17 Server      CLR version v4.0.30319 loaded.
    2016-11-11 06:59:22.25 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2016-11-11 06:59:22.31 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2016-11-11 06:59:22.32 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2016-11-11 06:59:22.36 spid7s      SQL Trace ID 1 was started by login "sa".
    2016-11-11 06:59:22.36 spid7s      Server name is 'WINDOWS-UMNHGU2\SQLEXPRESS'. This is an informational message only. No user action is required.
    2016-11-11 06:59:22.37 spid14s     Password policy update was successful.
    2016-11-11 06:59:22.37 spid14s     Error: 17190, Severity: 16, State: 1.
    2016-11-11 06:59:22.37 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2016-11-11 06:59:22.37 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2016-11-11 06:59:22.38 spid14s     Error: 17182, Severity: 16, State: 1.
    2016-11-11 06:59:22.38 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 
    2016-11-11 06:59:22.38 spid14s     Error: 17182, Severity: 16, State: 1.
    2016-11-11 06:59:22.38 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 
    2016-11-11 06:59:22.38 spid14s     Error: 17826, Severity: 18, State: 3.
    2016-11-11 06:59:22.38 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2016-11-11 06:59:22.38 spid14s     Error: 17120, Severity: 16, State: 1.
    2016-11-11 06:59:22.38 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


    desarrollador .NET

    sábado, 12 de noviembre de 2016 7:12
  • Saludos

    Tu error esta aqui

    2016-11-11 06:59:22.37 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2016-11-11 06:59:22.37 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2016-11-11 06:59:22.38 spid14s     Error: 17182, Severity: 16, State: 1.
    2016-11-11 06:59:22.38 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 

    Con que cuenta de servicio estas inicializando SQL Server? es un ambiente productivo o de pruebas sino intenta cambiar la cuenta de servicio a system sino tienes mayor problema e intenta de esta manera sino danos mas información.


    • Editado Enrique AA sábado, 12 de noviembre de 2016 23:10
    sábado, 12 de noviembre de 2016 23:10
  • Es un ambiente de pruebas.

    ¿A que te refieres con cuenta de servicio?

    ¿Como cambio la cuenta de servicio?



    desarrollador .NET

    domingo, 13 de noviembre de 2016 17:24
  • Saludos

    Disculpa la tardanza

    http://sqlservertoolbox.blogspot.mx/2015/01/cambiar-cuentas-de-sistema-windows-8-y.html

    Aqui toco el tema usa la system o nt network service esas no deberian de presentar este problema.  

    domingo, 13 de noviembre de 2016 23:22
  • No me ha funcionado, cree el usuario "sqlservices" y coloque esto en Log on: sqlservices\MSSQL$SQLEXPRESS , me dice contraseña incorrecta, pero estoy seguro que estoy ingresando la correcta


    desarrollador .NET

    lunes, 14 de noviembre de 2016 3:15
  • Saludos

    Ya existen pre hechas busca una que se llama system, esta no te deberia de dar problemas, vamos por este camino por el momento.

    lunes, 14 de noviembre de 2016 14:17
  • umm

    si solo coloco "system" , me arroja este error : WMI Provider Error [Call to WMI Provider Returned error code 0x800703b1]


    desarrollador .NET

    martes, 15 de noviembre de 2016 2:28
  • Saludos

    Por favor buscame en skype como "enriarg"

    martes, 15 de noviembre de 2016 3:01