Post reply

SQL Server Installation via cmd - specifying folder

  • August 22, 2018 at 12:19 am

    #408290

    I am learning to install SQL Server using cmd. This is my command

    C:\[foldername]>SQLServer2017-SSEI-Dev.exe /ACTION=install /QS /INSTANCENAME="MSSQLSERVER" /IACCEPTLICENCETERMS=1 /FEATURES=SQLENGINE,SSRS /SQLSYSADMINACCOUNTS="domain\[loginname]"

    when specifying foldername and domain/loginname it works fine.
    The thing is that I want to install it without manual interference, by that I mean when running this, it automatically opens up the  window in the first image(SQL Developer 2017) which asks me to accept license terms but I have already accepted it using /IACCEPTLICENCETERMS=1 . After that, when I click accept it asks where to install. By specifying it installation starts. But I want this process to be without that window opening, so I don't have to accept license terms second time and if it is possible I want to specify the folder name (where to install) as a cmd command parameter.
    Thanks for your time. 

  • August 22, 2018 at 12:31 am

    #2002793

    You can use the installer to generate a configuration file, then subsequently use that to automate the process of installation. https://docs.microsoft.com/en-gb/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-2017

  • August 22, 2018 at 1:23 am

    #2002797

    andycadley - Wednesday, August 22, 2018 12:31 AM

    You can use the installer to generate a configuration file, then subsequently use that to automate the process of installation. https://docs.microsoft.com/en-gb/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-2017

    That is the only way not to encounter that automatic page again?

  • August 22, 2018 at 1:57 am

    #2002798

    Have you tried some of the parameters described here?  INSTALLSHAREDDIR and INSTANCEDIR look as if they may be what you're looking for?

    John

  • August 22, 2018 at 2:10 am

    #2002799

    John Mitchell-245523 - Wednesday, August 22, 2018 1:57 AM

    Have you tried some of the parameters described here?  INSTALLSHAREDDIR and INSTANCEDIR look as if they may be what you're looking for?

    John

    Thanks for help. I used these parameters but it doesn't help, the window still pops up

  • August 22, 2018 at 12:18 pm

    #2002901

    elea.grig - Wednesday, August 22, 2018 2:10 AM

    John Mitchell-245523 - Wednesday, August 22, 2018 1:57 AM

    Have you tried some of the parameters described here?  INSTALLSHAREDDIR and INSTANCEDIR look as if they may be what you're looking for?

    John

    Thanks for help. I used these parameters but it doesn't help, the window still pops up

    Use a configuration file for installation .In your .ini file you can mention :-
    ACTION="Install"

    ; Specifies that SQL Server Setup should not display the privacy statement when ran from the command line.

    SUPPRESSPRIVACYSTATEMENTNOTICE="True"

    ; By specifying this parameter and accepting Microsoft R Open and Microsoft R Server terms, you acknowledge that you have read and understood the terms of use.

    IACCEPTROPENLICENSETERMS="True"

    ; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system.

    ENU="True"

    ACTION="Install"

    ; Specifies that SQL Server Setup should not display the privacy statement when ran from the command line.

    SUPPRESSPRIVACYSTATEMENTNOTICE="True"

    ; By specifying this parameter and accepting Microsoft R Open and Microsoft R Server terms, you acknowledge that you have read and understood the terms of use.

    IACCEPTROPENLICENSETERMS="True"

    ; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system.

    ENU="True"

    ;added for quiet install
    IACCEPTSQLSERVERLICENSETERMS="True"

    ; Setup will not display any user interface.
    "
    QUIET="True"

    ; Setup will display progress only, without any user interaction.

    QUIETSIMPLE="False"

    ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block.

    ;UIMODE="Normal"

    ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.

    UpdateEnabled="True"

    ; If this parameter is provided, then this computer will use Microsoft Update to check for updates.

    USEMICROSOFTUPDATE="False"

    ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install shared components.

    FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,BC,BOL

    IACCEPTSQLSERVERLICENSETERMS="True"

    ; Setup will not display any user interface.

    QUIET="True"

    ; Setup will display progress only, without any user interaction.

    QUIETSIMPLE="False"

    ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block.

    ;UIMODE="Normal"

    ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.

    UpdateEnabled="True"

    ; If this parameter is provided, then this computer will use Microsoft Update to check for updates.

    USEMICROSOFTUPDATE="False"

    ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install shared components.

    FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,BC,BOL

  • August 22, 2018 at 12:21 pm

    #2002904

    elea.grig - Wednesday, August 22, 2018 1:23 AM

    That is the only way not to encounter that automatic page again?

    I don't know if it's the only way, but I believe it is the recommended way of setting up an unattended install.

  • August 24, 2018 at 3:44 pm

    #2003291

    Did you try the install with the /Q or /QS options?

    Joie Andrew
    "Since 1982"

  • August 25, 2018 at 12:40 am

    #2003307

    Joie Andrew - Friday, August 24, 2018 3:44 PM

    Did you try the install with the /Q or /QS options?

    Yes

  • August 25, 2018 at 2:11 am

    #2003308

    You're installing the full SQL Server, right? You have /IACCEPTLICENCETERMS=1 listed but I am pretty sure that the license agreement flag is /iacceptsqlserverlicenseterms and it is specified without any =1 or =true.

    https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-2017

    Joie Andrew
    "Since 1982"

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy