Scripting Question

Install SQL Server 2016 for 300 machines

03/28/2017 980 views


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:


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?



0 Comments   [ + ] Show comments


All Answers

Errrr...why? Why wouldn't you create a server, install SQL Server on it and point your users at that?

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].
Answered 03/29/2017 by: VBScab
Red Belt

I want to depoly for 300 servers with sccm package.
Answered 03/29/2017 by: j23_123
White Belt

It's always good to get the full story AFTER one has replied [eyes wide]

Anyway...the same applies. The server name - exactly like a workstation name - is unique: no need for separate instance names.
Answered 03/30/2017 by: VBScab
Red Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ