Community Forums
Page 2 of 2 FirstFirst 12
Results 6 to 10 of 10

Thread: How to include SQL Server 2017 Express edition in Installation Requirements section

  1. #6
    Join Date
    Jul 2018
    Posts
    15
    Quote Originally Posted by BINUTB View Post
    Hi Jenifer,

    That means how to automatically install SQL Server 2017 Express through the install setup file created by Install Shield.

    While running setup file message "SQL Sever 2017 Express need to be installed for the installation to continue" will shown.
    My requirement is automatic installation of SQL Sever 2017 Express while running setup file.

    Regards
    Binu

    Hi

    Anybody have an idea about my requirement ?

    ie: i wish to install SQL Sever 2017 Express automatically by the setup file created by Install Shield.


    Regards
    Binu

  2. #7
    Join Date
    Jun 2017
    Posts
    132
    Quote Originally Posted by BINUTB View Post
    Hi

    Anybody have an idea about my requirement ?

    ie: i wish to install SQL Sever 2017 Express automatically by the setup file created by Install Shield.


    Regards
    Binu
    Hi,

    System requirement section can only alert you whether your installation has all things setup,it can't help you with installation.For that you need to add pre-requisite for SQL2017 express installation.Hereby attaching sample pre-requisite file for SQL-2016 express,you can change it accordingly for SQL-2018 express.

    Links from where you want to download sql setup you can search it online.

    Microsoft SQL Server 2016 Express RTM (x64) - Copy.txt

    Thanks,
    Jenifer

  3. #8
    Join Date
    Jul 2018
    Posts
    15
    Thanks Jenifer

  4. #9
    Join Date
    Jul 2018
    Posts
    15
    Quote Originally Posted by Jenifer View Post
    Hi,

    System requirement section can only alert you whether your installation has all things setup,it can't help you with installation.For that you need to add pre-requisite for SQL2017 express installation.Hereby attaching sample pre-requisite file for SQL-2016 express,you can change it accordingly for SQL-2018 express.

    Links from where you want to download sql setup you can search it online.

    Microsoft SQL Server 2016 Express RTM (x64) - Copy.txt

    Thanks,
    Jenifer


    Hi Jenifer,


    Added Pre-requisite for SQL Server 2017 Express

    below is the .prq file

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <SetupPrereq>
    <files>
    <file LocalFile="C:\SBNT\PreRequisite\SQLServer2017-SSEI-Expr.exe" CheckSum="5B232C8BB56935B9E99A09D97D3494EA" FileSize="0,5325976"/>
    </files>
    <execute file=""/>
    <properties Id="{EC0DF766-0455-40AA-AA3C-A98EBA767398}"/>
    <behavior Lua="1"/>
    </SetupPrereq>



    On running setup file SQL Server 2017 Express is not installed in the target pc

    Please advise the reason/ any additional steps required for this

    Thanks in advance

    Regards
    Binu

  5. #10
    Join Date
    Jun 2017
    Posts
    132
    Quote Originally Posted by BINUTB View Post
    Hi Jenifer,


    Added Pre-requisite for SQL Server 2017 Express

    below is the .prq file

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <SetupPrereq>
    <files>
    <file LocalFile="C:\SBNT\PreRequisite\SQLServer2017-SSEI-Expr.exe" CheckSum="5B232C8BB56935B9E99A09D97D3494EA" FileSize="0,5325976"/>
    </files>
    <execute file=""/>
    <properties Id="{EC0DF766-0455-40AA-AA3C-A98EBA767398}"/>
    <behavior Lua="1"/>
    </SetupPrereq>



    On running setup file SQL Server 2017 Express is not installed in the target pc

    Please advise the reason/ any additional steps required for this

    Thanks in advance

    Regards
    Binu
    Hi,

    You are missing core part in pre-requisite file,i.e <execute> entries.I hope you had removed conditions & operating system conditions since you dont want it explicitly.

    Please have a look at following sample entry:
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <SetupPrereq>
    <files>
    <file LocalFile=".\SQLServerExpress\2016\x64\SQLEXPR_x64_ENU.exe" URL="https://download.microsoft.com/download/E/1/2/E12B3655-D817-49BA-B934-CEB9DAC0BAF3/SQLEXPR_x64_ENU.exe" CheckSum="902347C4F97B2CB00007C74AE1A6912E" FileSize="0,315579864"/>
    </files>
    <execute file="SQLEXPR_x64_ENU.exe" cmdline="/qs /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /IAcceptSQLServerLicenseTerms /SkipInstallerRunCheck" cmdlinesilent="/q /HIDECONSOLE /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /IAcceptSQLServerLicenseTerms /SkipInstallerRunCheck" requiresmsiengine="1"/>
    <properties Id="{C00B2D46-778B-48C4-85A4-2FB52524ECBE}" Description="This installs a native 64-bit Microsoft SQL Server 2016 Express Edition (SQL Server Express) onto only 64-bit operating systems. The /q switch suppresses all Setup dialog boxes and error messages. See https://msdn.microsoft.com/en-us/lib...=sql.130).aspx for more information." AltPrqURL="http://saturn.installshield.com/devstudio/setuprequirements/sqlexpress2016/Microsoft SQL Server 2016 Express RTM (x64).prq"/>
    </SetupPrereq>

    Things to correct:
    -Give files\file\LocalFile entry as relative path,so that it can pick from the folder irrespective of specific machine.
    -Fill execute details with file.commandline ,action etc which is mandatory

    Hope it helps,
    Thanks,
    Jenifer

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •