In this installation sql server required settings are saved to a configuration file and this file is used as a parameter to install sql server.
Configuration file creation is a one time job. And this is done as below
Run setup.exe as attended installation(GUI) based installation select your requirement
once when you are done with Feature Selection now select the Instance Configuratiion and give the name of default instance or named Instane,i have used named Instance as below
In the above example I have use SQL2014 as my named instance, and this name will be saved in configuration files . all the installation done using this configuration file will have the same instance name.
Now cancel the installation and open the configurationfile.
Make the changes in the configurationfile.
- Remove the UIMODE=”Normal”
- Remove the ADDCURRENTUSERASSQLADMIN=”False”
- Add IACCEPTSQLSERVERLICENSETERMS=”True”
Once done with changes
Open cmd as run as administrator
Relocate to the instaltion folder any type the below command