August 16, 2002 at 8:48 am
Recently uncovered a problem on a failover where our static IP changed (doesn't make sense). I've come across a TCPPORT registry key, but I don't believe setting that stops SQL from changing the value. What I am looking for is a key to possibly lock that value in so that no program can alter it. Kind of a MaintainPort key or something to that effect. Any ideas?
August 16, 2002 at 9:52 am
Not likely to be anyway to do this except permissions. Is this a big problem?
Steve Jones
August 16, 2002 at 10:22 am
It was a big problem yesterday when it failed. Just trying to prevent it from becoming a big problem again. We're not even sure how a static port could be changed, but though maybe since there was a key to set the port there may be a key to lock it.
August 16, 2002 at 1:57 pm
Did the IP or the port change? Was it a clustered instance?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 16, 2002 at 8:58 pm
just the port and yes it was clustered
August 17, 2002 at 9:16 am
Did anyone change it using the Server Network Utility?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy