How to Create configuration files for installation of SQL Server

• mac_live

  Ten Centuries

  Points: 1021

  More actions

  August 22, 2013 at 2:30 am

  #298061

  Hi,

  I am Looking for procedure that create a configuration file for installation of sql server and how it works. can any one help me out?. Thanks. Replays are most welcome.

  Cheers

• rodbloke

  SSCommitted

  Points: 1612

  More actions

  August 22, 2013 at 3:17 am

  #1643803

  Hi, the easiest way to get you started I think is to use the Configuration File generated by SQL 2008+. If you go through the motions of an install, choosing all of the options that you want as part of your standard, but stop on the 'Ready to Install' screen before you click Install. At the bottom of this screen is a Configuration File Path: section. Something like...

  C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130822_100924\ConfigurationFile.ini

  SQL has generated this automatically using the options you've selected. Take a copy of it and it should contain almost all that you need.

  Cheers

  Rod

• rodbloke

  SSCommitted

  Points: 1612

  More actions

  August 22, 2013 at 3:23 am

  #1643805

  Sorry, forgot to include how to use it

  http://msdn.microsoft.com/en-us/library/df40c888-691c-4962-a420-78a57852364d(v=sql.100).aspx

  Basically...something like..

  setup.exe /ACTION=INSTALL /CONFIGURATIONFILE= {......} etc.

• mac_live

  Ten Centuries

  Points: 1021

  More actions

  August 22, 2013 at 4:05 am

  #1643824

  Thanks Very much Rod.