First published on MSDN on Aug 17, 2016
Recently I delivered a demo on Policy Based Management for a customer. To show this off well, I really wanted to have a larger number of SQL servers to show how PBM can be used to manage SQL Server sprawl. I can only fit a few VMs in my laptop and Azure would burn though my $150 MSDN credit too quickly, so I decided to look for other options. I then remembered that SQL Server supports up to 50 instances on the same machine .
I’m too lazy to click Next > Next > Next that many times, so I made a script to automatically install 50 instances of SQL on the same machine.
!!WARNING!!! - This will blow up the size of your SQL install directory significantly! (about 1GB per instance with SQL 2016). Do not run this on production servers or any server that you even remotely care about!
If you are ok with this warning, you can get a copy of the script here .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.