August 29, 2002 at 3:06 pm
Using SQL2000, SP2.
Are there any issues with changing IP addresses of installed servers? I seem to recall that in earlier versions, the IP address was configured into SQL somewhere which meant a change in address usually meant a re-install. As my client is moving soon, which is forcing a change in IP addresses, I'd like to know if there are any expected problems?
Regards
Simon
August 29, 2002 at 3:41 pm
I have changed between IP addresses without issue in 2000, the only thing that might affect you is config of name to IP in Client Network utility may need to be updated on the machine and any clients that are setup that way.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 29, 2002 at 5:15 pm
Thanks, I'll bear it in mind - most clients connect using IP so they are being reviewed already. It's things like linked servers that bother me - will replication jobs need to be re-defined?
August 29, 2002 at 5:44 pm
This is true on a stand alone system but just in case someone reads this thread with a clustered server... If you are changing the IP address on a clustered SQL Server, re-run setup. Don't change the IP address through cluadmin. Stuff WILL break.
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 29, 2002 at 7:21 pm
Good advice, thanks for adding that in.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 30, 2002 at 9:50 am
Been there, done that. You can fix it by going into the registry, but it's not a welcome experience. We had contractors set up a clustered sql server and then decide to change the IP. They weren't experienced with SQL Server and didn't know. Spent 4 or 5 hours until we tracked down what happened. I don't want anyone to have to endure that.
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
September 2, 2002 at 1:02 am
Hi Brian
RE: Change IP on clustered servers..you mention in this thread that setup should be rerun. Also you mention reg entries which can be changed to rectify the problem of a changed IP on clustered servers.
A client is about to go thru an IP change which probably will include servers which house our db. Is there documentation I can review / point them at to pre-empt the case issues you refer to?
September 3, 2002 at 11:24 am
It looks like Microsoft's support site are having some problems, but here are the relevant Q articles, titles, and links.
PRB: SQL Server 2000 Cluster May Not Bind to Port If SQL Server IP Address Is Changed (Q319578)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319578
HOWTO: Change the Network IP Addresses on a Virtual SQL Server (Q244980)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244980
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings (Q254321)
http://support.microsoft.com/default.aspx?scid=kb;en-us;q254321
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
September 10, 2002 at 1:47 pm
From this thread looks like there are no worries about changing IP address for W2K servers, what about 7.0 servers?
We are moving to a new building and will need to change SQL Server IP addresses for both SQL 7.0 and W2K boxes.
Any impacts would be nice to know.
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 11, 2002 at 8:03 am
I've changed IPs without too much trouble before. If you aren't using a virtual server, SQL Server binds to the IP address of the system on the port specified. The virtual server, which has a hard-coded IP address, is the issue in most cases.
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
September 11, 2002 at 8:15 am
That's what I thought, just wanted to confirm. Thank you for the information.
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply