Jack Vamvas has a cmdlet for us:
Question: I have an SQL Server Instance – currently configured with a Dynamic Port. I’d like to change the setting from a Dynamic port configuration to a Static port configuration , using Powershell.
I want to change to a static port as we need to set up some Firewall rules , and using a static port will be much easier
How can this be done?
Click through for the answer.