[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
How to Use a Configuration File to Install SQL Server

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

How to Use a Configuration File to Install SQL Server.


Applies to: Microsoft SQL Server 2008 R2.


The use of configuration files to install SQL Server helps to automate and standardize SQL Server installations.

If you will like to use a Configuration file to install SQL Server, you will need to build a configuration as explained on this MSDN article using Notepad or any utility that creates text files.

Here you will find a sample configuration file built to add the Analysis Services feature to an existing instance of SQL Server. Take in consideration that SQL Server Express Edition does not support Analysis Services, thus this sample configuration file only run on Datacenter, Enterprise and Standard edition.

To run SQL Server setup using a configuration file, you can run the following command at the Command Prompt assuming the media is located on the D drive (DVD drive):
 

D:setup.exe /ConfigurationFile="ConfigurationFile.ini" /IAcceptSQLServerLicenseTerms


If you are installing SQL Server Express or SQL Server Express with Tools, then the name of SQL Server setup executable may vary. Probably you may have to run SQL Server setup like this, if it is a 64-bit installation:


SQLEXPR_x64_ENU.exe /ConfigurationFile="ConfigurationFile.ini" /IAcceptSQLServerLicenseTerms


For a 32-bit installation, the command should be modified as shown below:


SQLEXPR_x86_ENU.exe  /ConfigurationFile="ConfigurationFile.ini" /IAcceptSQLServerLicenseTerms


If you are installing SQL Server Express with Advanced Services, then name of SQL Server setup may vary. Probably you may have to run SQL Server setup like this, if it is a 64-bit installation:
 

SQLEXPRADV_x64_ENU.exe  /ConfigurationFile="ConfigurationFile.ini" /IAcceptSQLServerLicenseTerms


For a 32-bit installation, the command should be modified as shown below:


SQLEXPRADV_x86_ENU.exe  /ConfigurationFile="ConfigurationFile.ini" /IAcceptSQLServerLicenseTerms



References.


How to: Install SQL Server 2008 R2 Using a Configuration File.



 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.