none
Looking for automation script

    Question

  • Hi there,

    We need to install Express 2014 Edition in 100 machines (out of domain) and we are looking some scripts intended for it. Idea is apply same installation features (M: mdf, L:ldf, same collation, etc..)

    Thanks for sharing your links,

    Tuesday, January 3, 2017 9:48 AM

Answers

  • You can go for un-attended SQL Server Installation using a configuration file. This configuration file has all the information of Path, Location of Data and Log file, tempdb, Error log, Service account etc..etc

    https://msdn.microsoft.com/en-in/library/dd239405(v=sql.120).aspx

    Just do one install manually and during the setup wizard it will display the configuration file path to you. You can copy this file and use for rest of the installs.

    You just need execute following form SQL Server media directory: 

    Setup.exe /ConfigurationFile=MyConfigurationFile.INI 

    You can use powershell to push this from one Machine to rest or machines.

    You can also use System Center for this.

    Thanks,

     

    Kindly mark the reply as answer if they help

    • Marked as answer by Enric Vives Tuesday, January 3, 2017 10:44 AM
    Tuesday, January 3, 2017 10:02 AM

All replies