August 22, 2018 at 12:19 am
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
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
andycadley - Wednesday, August 22, 2018 12:31 AMYou 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 2:10 am
John Mitchell-245523 - Wednesday, August 22, 2018 1:57 AMHave 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
elea.grig - Wednesday, August 22, 2018 2:10 AMJohn Mitchell-245523 - Wednesday, August 22, 2018 1:57 AMHave 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
elea.grig - Wednesday, August 22, 2018 1:23 AMThat 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
Did you try the install with the /Q or /QS options?
Joie Andrew
"Since 1982"
August 25, 2018 at 12:40 am
Joie Andrew - Friday, August 24, 2018 3:44 PMDid you try the install with the /Q or /QS options?
Yes
August 25, 2018 at 2:11 am
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.
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
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