Monday, 3 June 2013

PowerShell Script to Assign Static TCP Port to SQL Server Instance

I am designing a new SQL server Farm with more than 100 Instances for one of my clients and it would have been huge effort if I had to assign static TCP to each and every instance manually, but Thanks to Allen Whites Blog on PowerShell Managed Computer Objects in SMO ,This namespace pretty much gives us ability to do all the tasks which are done through Configuration Manager using PowerShell. I have written a wrapper over Allen Whites core script to assign Static port to SQL instances.
Copyright © 2013 Vinoth N Manoharan.The information provided in this post is provided "as is" with no implied warranties or guarantees.


  1. Where to get these related services? Make sure they are all right.

  2. Its work! Thanks!

  3. This script is very handy! Had a lot of trouble configuring the ports of my named instance on server core. Until I stumbled on your script.

    Many thanks