none
Ошибка установки SQL Server 2017 Express - The object state property 'this.InstanceId' is RRS feed

  • Вопрос

  • Доброе время суток. Пытаюсь поставить SQL Server 2017 Express на Windows Server 2016 STD Core, команды:
    setup.exe /qs /IACCEPTSQLSERVERLICENSETERMS /action=install /features=sql,tools /instancename=sql_srv_exp_1 sqlsvcaccount="win_srv_2016_std_core_test\sql_account" /sqlsvcpassword=****** /sqlsysadminaccounts=win_srv_2016_std_core_test\admin" /installsqldatadir=d:\sql_data /securitymode=sql sapwd=******
    Получаю ошибку:
    The following error occurred:
    The object state property 'this.InstanceId' is null/empty.

    Error result: -2068709375
    Result facility code: 1202
    Result error code: 1

    Please review the summary.txt log for further details


    - Пробовал добавлять к моей строке /instanceid=140, /instanceid=sql_srv_exp_1 - получаю ту же самую ошибку. Файл summary.txt ниже. В чем причина проблемы ?

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2068709375
      Exit facility code:            1202
      Exit error code:               1
      Exit message:                  The object state property 'this.InstanceId' is null/empty.
      Start time:                    2020-01-20 21:17:43
      End time:                      2020-01-20 21:18:55
      Requested action:              Install
      Exception help link:           https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=0x8065E555%400xF762992B%401202%401&EvtType=0x8065E555%400xF762992B%401202%401


    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Replication:     SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for ComponentUpdate: SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SNAC:            SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SNAC_SDK:        SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Writer:          SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Browser:         SQL Server Setup was canceled before completing the operation. Try the setup process again.




    Machine Properties:
      Machine name:                  WIN_SRV_2016_ST
      Machine processor count:       1
      OS version:                    Microsoft Windows Server 2016 Standard - ServerCore (10.0.14393)
      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


    Package properties:
      Description:                   Microsoft SQL Server 2017 
      ProductName:                   SQL Server 2017
      Type:                          RTM
      Version:                       14
      SPLevel:                       0
      Installation location:         d:\install\sql_srv_2017_express\SQLEXPR_x64_ENU\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:                  TABULAR
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTELSVCACCT:                  <empty>
      ASTELSVCPASSWORD:              <empty>
      ASTELSVCSTARTUPTYPE:           0
      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
      EXTSVCACCOUNT:                 <empty>
      EXTSVCPASSWORD:                <empty>
      FEATURES:                      SQLENGINE, REPLICATION
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTPYTHONLICENSETERMS:     false
      IACCEPTROPENLICENSETERMS:      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:                    
      INSTANCENAME:                  
      ISMASTERSVCACCOUNT:            NT AUTHORITY\Network Service
      ISMASTERSVCPASSWORD:           <empty>
      ISMASTERSVCPORT:               8391
      ISMASTERSVCSSLCERTCN:          <empty>
      ISMASTERSVCSTARTUPTYPE:        Automatic
      ISMASTERSVCTHUMBPRINT:         <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      ISTELSVCACCT:                  <empty>
      ISTELSVCPASSWORD:              <empty>
      ISTELSVCSTARTUPTYPE:           0
      ISWORKERSVCACCOUNT:            NT AUTHORITY\Network Service
      ISWORKERSVCCERT:               <empty>
      ISWORKERSVCMASTER:             <empty>
      ISWORKERSVCPASSWORD:           <empty>
      ISWORKERSVCSTARTUPTYPE:        Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      MRCACHEDIRECTORY:              
      NPENABLED:                     0
      PBDMSSVCACCOUNT:               <empty>
      PBDMSSVCPASSWORD:              <empty>
      PBDMSSVCSTARTUPTYPE:           0
      PBENGSVCACCOUNT:               <empty>
      PBENGSVCPASSWORD:              <empty>
      PBENGSVCSTARTUPTYPE:           0
      PBPORTRANGE:                   <empty>
      PBSCALEOUT:                    false
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   true
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  Cyrillic_General_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQL$
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           win_srv_2016_std_core_test\admin /installsqldatadir=d:\sql_data /securitymode=sql sapwd=******** /instanceid=sql_srv_exp_1 /ACTION=install
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY
      SQLTELSVCPASSWORD:             <empty>
      SQLTELSVCSTARTUPTYPE:          Automatic
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBFILECOUNT:            1
      SQLTEMPDBFILEGROWTH:           64
      SQLTEMPDBFILESIZE:             8
      SQLTEMPDBLOGDIR:               <empty>
      SQLTEMPDBLOGFILEGROWTH:        64
      SQLTEMPDBLOGFILESIZE:          8
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false


      Configuration file:            C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20200120_211742\ConfigurationFile.ini


    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       SQL Server Replication
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       Setup Support Files
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       SQL Client Connectivity
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       SQL Client Connectivity SDK
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       SQL Writer
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


      Feature:                       SQL Browser
      Status:                        Failed
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.


    Rules with failures:


    Global rules:


    Scenario specific rules:


    Rules report file:               C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20200120_211742\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.ChainerInvalidOperationException
        Message: 
            The object state property 'this.InstanceId' is null/empty.
        HResult : 0x84b20001
            FacilityCode : 1202 (4b2)
            ErrorCode : 1 (0001)
        Data: 
          ChainerInvalidOperationExceptionData = this.InstanceId
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Configuration.SqlConfigBase.InstanceIdPrivateConfigObject.ValidateSettings()
            at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.ValidateSettings(IEnumerable`1 settingIds)
            at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)

    20 января 2020 г. 15:28

Ответы

Все ответы