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?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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..

Answered 03/12/2013 by: jagadeish
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity