none
Error during installation of SQL Express 2016 from Inno Setup Script

    Question

  • I have a problem when installing SQL Express 2016 from Inno Setup Script, this only happens from the setup program, but not from the command line using the same command which is: 

    SQLEXPR_x64_ENU.exe /QS /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQL /INSTANCENAME=SEMR /SECURITYMODE="SQL"" /SAPWD="sa1234"  /SQLSVCACCOUNT=""Local Service" /BROWSERSVCSTARTUPTYPE="Automatic" /SQLSVCSTARTUPTYPE="Automatic" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="Local Service"

    running the same command from command line installs sucessfuly, the log file when installing from Inno setup is as follows:

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2147467261
      Exit facility code:            0
      Exit error code:               16387
      Exit message:                  Value cannot be null.  Parameter name: userName
      Start time:                    2017-04-29 19:17:57
      End time:                      2017-04-29 19:18:40
      Requested action:              Install
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x3B1BDD8F%400x11428655&EvtType=0x3B1BDD8F%400x11428655

    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.


    Machine Properties:
      Machine name:                  DESKTOP-56GT64Q
      Machine processor count:       4
      OS version:                    Microsoft Windows 10 Pro (10.0.10240)
      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 2016      SQLEXPRESS           MSSQL13.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      13.1.4001.0     No         Yes       
      SQL Server 2016      SQLEXPRESS           MSSQL13.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      13.1.4001.0     No         Yes       
      SQL Server 2016                                                          SSMS                                     1033                                      13.0.16100.1    No         Yes       
      SQL Server 2016                                                          Adv_SSMS                                 1033                                      13.0.16100.1    No         Yes       

    Package properties:
      Description:                   Microsoft SQL Server 2016 
      ProductName:                   SQL Server 2016
      Type:                          RTM
      Version:                       13
      Installation location:         C:\Users\mmedhat\AppData\Local\Temp\is-RHR4F.tmp\SQLEXPR_x64_ENU\x64\setup\
      Installation edition:          Express

      Slipstream:                    True
      SP Level                       1

    Product Update Status:
      Success: KB 3182545

    Product Updates Selected for Installation:
      Title:                         Microsoft SQL Server 2016  Express SP1
      Knowledge Based Article:       KB 3182545
      Version:                       13.1.4001.0
      Architecture:                  x64
      Language:                      1033

      Update Source:                 Slipstream


    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>
      ASTELSVCACCT:                  <empty>
      ASTELSVCPASSWORD:              <empty>
      ASTELSVCSTARTUPTYPE:           0
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Automatic
      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
      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:                    SEMR
      INSTANCENAME:                  SEMR
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      ISTELSVCACCT:                  <empty>
      ISTELSVCPASSWORD:              <empty>
      ISTELSVCSTARTUPTYPE:           0
      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
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  Arabic_CI_AS
      SQLSVCACCOUNT:                 
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           BUILTIN\ADMINISTRATORS
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SEMR
      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:                  Slipstream
      USEMICROSOFTUPDATE:            false
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170429_191755\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      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: see logs for details
      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\130\Setup Bootstrap\Log\20170429_191755\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: System.ArgumentNullException
        Message: 
            Value cannot be null.
            Parameter name: userName
        HResult : 0x80004003
        Data: 
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Configuration.Sco.UserSecurity.IsVirtualAccount(ServiceContainer ctx, String userName)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccount(String sqlAccount, SqlSecureString sqlPassword, ConfigActionScenario scenario, Boolean isExpressSku)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccountForInstall()
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateInstallInput()
            at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.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)

    Saturday, April 29, 2017 4:33 PM

All replies

  • Hi mmedhat01,

     

    Have you specified the Inno Setup to use the Administrator permission? This problem is always related to the .net framework. Using Administrator to install it can solve this problem.

     

    Please add the following code before the installation code:

     

    [Setup]
    PrivilegesRequired=admin

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, May 1, 2017 6:53 AM
    Moderator