I will make simple and short. PowerShell command uses SQL Browser service to populate the local SQL servers and instances on the network.
So the requirements are:
- SQL Browser service installed and running (or run it on a SQL server)
- You should be a Administrator (preferably domain admin)
- You have to run this command on each site (on one of the local server)
Open PowerShell and run this command.
Things are getting much easier these days. 🙂