SQL Server allows to generate configuration file and using this file we can deploy sql instance with same configuration for different server. We can also standardize manual for installing sql with batch files which will launch SQL setup.
Setup supports the use of the configuration file only through the command prompt. The configuration file overwrites the defaults in a package and Command-line values overwrite the values in the configuration file
The configuration file can be used to track the parameters and values for each installation. This makes the configuration file useful for verifying and auditing the installations.
The ConfigurationFile.ini file is a text file with parameters (name/value pair) and descriptive comments.
To generate configuration file we need to start setup using media (setup.exe) till ready to install page.
The path to the configuration file is specified in the Ready to Install page in the configuration file path section.
Then cancel the setup,
Normally file location would be : File Location and Name: %programfiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\
To see the progress of installation during setup using ConfigurationFile.ini we can manually edit the file and set the parameter INDICATEPROGRESS to TRUE and QUITESIMPLE to TRUE.
NB: In ConfigurationFile.ini sa password not be included even if you have entered while creating file, we must add parameter SAPWD=”Password” below SECURITYMODE=SQL in file to include sa password or we can add later after installation done.
To install the SQL=>
Copy ConfigurationFile.ini to setup folder where setup.exe is and use command prompt to use syntax from setup folder:
ð Setup / ConfigurationFile= ConfigurationFile.ini
To specify passwords at the command prompt instead of in the configuration file:
ð Setup.exe /SQLSVCPASSWORD="*****" /AGTSVCPASSWORD="*****" /ASSVCPASSWORD="*****" /ISSVCPASSWORD="*****" /RSSVCPASSWORD="******” /SECURITYMODE=SQL /SAPWD ="******” /ConfigurationFile=MyConfigurationFile.INI