SQL Server 2012 Instance Configuration
Hi. I'm a packager that has been asked if it is possible when deploying SQL Server 2012 through SCCM (pull rather than a push) to allow the engineer to choose whether the install will be a default instance or a named instance? They would like to avoid having two installers for each version of SQL (a named instance and a default instance). They also felt it would be helpful to allow the user to input their own name for the named instance. I've deployed SQL Server 2008 R2 using the INI file with custom settings so that we have a silent install. This was a default instance. Is this request even possible and if so, any suggestions on how to make the package to pause the install for input for the "INSTANCEID=" value?
Answers (1)
You can also install SQL Server 2012 using following command line
Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS
You can run the above command line using VBScript, where INSTANCENAME will be obtained from the user during runtime..