October 11, 2007 at 10:03 am
Will SQL Server Dynamic Port for named instance change every time SQL Server get restarted or it will use the same port as the dynamic port as long as the port is available?
I did a few tests, and seems like it's staying with the same dynamic port will sql server get restarted.
Thanks.
October 11, 2007 at 3:52 pm
according to this article, upon shutdown and restart of SQL Server another port is selected
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1638388&SiteID=1
October 12, 2007 at 9:53 am
Thanks.
We have two named instances of SQL Server 2005 cluster on four nodes, if we are going to assign a static ports for each named instances, will this affect anything? Does anyone ever try to do this? Thank you.
October 12, 2007 at 10:28 am
it will try to use the port it used the previous time, but if that port is unavailable, it will switch to anothre port.
So if you want to use kerberos authentication, with the spn registration you need to provide a port. So you'll need to provide fixed portnumbers for the instance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply