PowerShell Script to configure SQL Server static Port

Updated: Jan 11

The article How to configure a static port for SQL Server? Explains the process of setting a non-default static port using SQL Server Configuration Manager. Can we do the same task using PowerShell Script?


Yes, we can set SQL Server static port using a PS script. Take the script from GitHub and open it in the Windows PowerShell IDE.


Specify the SQL Instance name ( in case of named instance) and SQL static port that we want to set. Execute the PowerShell script, and it sets static port followed by a restart SQL Service to take new port in effect.



PowerShell script to modify SQL Server port


38 views0 comments