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 http://sqlblog.com/blogs/allen_white/default.aspx ,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.

3 comments:

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

    ReplyDelete
  2. Its work! Thanks!

    ReplyDelete
  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

    ReplyDelete