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.
at

5 comments:

  1. Northfield Web Design1 April 2014 at 09:56

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

    ReplyDelete
  2. Alexei26 June 2014 at 00:56

    Its work! Thanks!

    ReplyDelete
  3. Jense12 March 2017 at 22:31

    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
  4. midn19 June 2020 at 01:37

    Cheap Moncler jackets , combining elegant style and cutting-edge technology, a variety of styles of Cheap moncler jackets men jackets , the pointer walks between your exclusive taste style.

    ReplyDelete
  5. James Zicrov22 August 2021 at 22:37

    I think this is a piece of very interesting information about SQL and other utilities as well.

    SQL Server Load Soap API

    ReplyDelete

Subscribe to: Post Comments (Atom)