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.
Where to get these related services? Make sure they are all right.
ReplyDeleteIts work! Thanks!
ReplyDeleteThis 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.
ReplyDeleteMany thanks
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.
ReplyDeleteI think this is a piece of very interesting information about SQL and other utilities as well.
ReplyDeleteSQL Server Load Soap API