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 9 (of 9 total)

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