March 11, 2009 at 5:48 am
After changing the IP adresses (network ip address change and not subnet change) on the windows 2003 server cluster, we have experienced issues with connecting to the instance. The instance still remembers the old ip address.
According to http://support.microsoft.com/kb/244980/ (Section - Change the IP addresses of SQL Server 2000 failover cluster instances)
we need to run sql 2000 setup and select advanced - Maintain a Virtual Server for Failover Clustering.
The sql 2000 service pack is 4
when running setup from the cd, it says it is a lesser version and will require sp3 min after the install.
The question is: if this is a simple ip address change, is the service pack going to be required to be reinstalled?
Also, when running the setup program according to the above knowledge base article, I am assuming the clustered instance needs to stay running.
March 11, 2009 at 7:02 am
The fix was to update the ip addresses at - HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\Cluster\ClusterIpAddr
ref: http://support.microsoft.com/kb/319578/
the problem was that the sql virtual server could not bind to tcp. running the setup program mentioned in the previous post was not necessary.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply