TransWikia.com

SQL Server Configuration File and InstanceName parameter

Database Administrators Asked by Aleksey Vitsko on December 5, 2020

We have a configuration file at E:SQL_Server_2016_InstallMyConfigFile.ini that looks like below:

[OPTIONS]
ACTION = "Install"
FEATURES = SQLENGINE
INSTANCENAME = MSSQLSERVER
AGTSVCACCOUNT = "MyDomainMyAccount"
SQLSVCACCOUNT = "MyDomainMyAccount"
QS
IACCEPTSQLSERVERLICENSETERMS

SQL Server is then installed using below batch file:
E:SQL_Server_2016_InstallSetup.exe /ConfigurationFile=MyConfigFile.ini /InstanceName="TestSQLServer"

Question:

Will /InstanceName="TestSQLServer" parameter override what we have in the configuration file (/InstanceName = MSSQLSERVER (default instance)), and install SQL Server as a named instance TestSQLServer ?

automationconfiguration fileinstallationsql server

One Answer

Will /InstanceName="TestSQLServer" parameter override what we have in the configuration file (/InstanceName = MSSQLSERVER (default instance)), and install SQL Server as a named instance "TestSQLServer" ?

Yes, per the below excerpt from the configuration file documentation :

  • The configuration file overwrites the defaults in a package

  • Command-line values overwrite the values in the configuration file

Correct answer by Dan Guzman on December 5, 2020

Add your own answers!

Ask a Question

Get help from others!

Recent Answers

Recent Questions

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP