Install SQL Server 2016 for 300 machines
Hello,
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?
Thks
JLV
Answers (3)
And even if you do need separate installations, why do you think you need separate instance names? If the individual boxes are going to host database(s), then users will simply connect to \\[name_of_box]\[instance name].
Anyway...the same applies. The server name - exactly like a workstation name - is unique: no need for separate instance names.