AnswerBun.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 ?

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!

Related Questions

HAPROXY for Postgres Failover Master/Replica

0  Asked on December 31, 2020 by jayson-gonzaga

       

Error 0xc000007b with Oracle 19c

2  Asked on December 28, 2020 by ben-a

       

Join to tables dynamically depending on data

2  Asked on December 28, 2020 by yellephen

   

PostgreSQL exits the shell when importing large data

2  Asked on December 26, 2020 by 3bdalla

   

Spike and time out errors every x th minute

1  Asked on December 25, 2020 by beginnerdba

     

Oracle RAC and DataGuard configuration

1  Asked on December 25, 2020 by yifan

         

Segragating First LSN and Last LSN from Output MySQL

0  Asked on December 24, 2020 by jabir-baig

     

Lossless Join Decomposition Criteria

1  Asked on December 23, 2020 by kevin-wu

   

Mongodb Upgrade from 1.8.2 to 4.4

0  Asked on December 23, 2020 by amanullah

   

SQLite database becomes corrupt

1  Asked on December 22, 2020 by jkozma

 

How do I export a multi table database with exceptions?

2  Asked on December 21, 2020 by soberuprising

     

MS SQL login periodically doesn’t work

2  Asked on December 20, 2020 by alonzo-hess

   

PostgreSQL: Find row with JSON object attribute in array

1  Asked on December 20, 2020 by karlsc

     

Hotel booking schema

1  Asked on December 20, 2020 by rakoun

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir