Install SQL Server 2016 for 300 machines
I need to install SQL Server 2016 for almost 300 machines. I have SCCM 2012 running in the company.
If was just a simple defaults instalations in the 300 machines there is no problem, but I have an instance name for each one. ex:machine 1 - instance name 1; machine 2 - instance name 2; etc.....
I can configure in SCCM a program like this:
Setup.exe" /ACTION=Install /q /IACCEPTSQLSERVERLICENSETERMS /IACCEPTROPENLICENSETERMS /FEATURES=SQLENGINE,FULLTEXT,CONN,IS,SNAC_SDK,BOL /INSTANCENAME="instancename" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCACCOUNT="NT Authority\System" /SQLSYSADMINACCOUNTS="user1" "user2" "user3" "user4" /ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
How do I modify this script to program read the machine name and fill the parameter /INSTANCENAME with the INSTANCENAME for that machine name?
Create a powershell script? Have a csv file with MACHINE NAME;INSTANCE NAME? Create a vbs? Any idea, sugestion?