Deploying SQL Server manually can be a lengthy and error prone process as need to go through all the different setup screens presented by the SQL Server Installation Center.
SQL Server present the way to install using command line parameters. Following are the list of SQL Server Installation parameters using Command Line:
SQL Server present the way to install using command line parameters. Following are the list of SQL Server Installation parameters using Command Line:
Press Windows+R to open “Run” box. Type “cmd”
1.Change your setup path
2.Add instance id and name
3.Sqlsysadminaccounts as your computer name
Add Components:
"G:\sql2012dev\setup.exe" /qs /ACTION=INSTALL /FEATURES=SSMS,SQLENGINE /INSTANCENAME=anurag /INSTANCEID=anurag /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
/SQLSVCPASSWORD="clover@1234"
/RSSVCACCOUNT="NT Service\ReportServer"
/SQLSYSADMINACCOUNTS="Anurag\Administrator" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /IACCEPTSQLSERVERLICENSETERMS
Remove Components:
To remove specific components or tools or services like Analysis services, Reporting services and integration services from specific instance. Use following command line parameters:
"C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012\setup.exe" /Action=Uninstall /FEATURES=AS,RS,IS /INSTANCENAME=Andy
Referenced link:
Silent installation of Sql server 2012 via command line
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms144259%28v%3dsql.110%29