Wednesday, March 28, 2012

Need to access the impact of changing IP address

we plan to move our sql server from one place to another place. It's IP has
to been changed, yet the hostname can be kept. I need to access the possible
impact of this move. Our application server query the datababase by server
name. Apart from changing the DNS, what else I have to pay attention ?
Nothing. SQL Server needs to have the same hostname for replication, but
other than that, as far as I know there will be no impact from changing the
IP address.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LanLan" <LanLan@.discussions.microsoft.com> wrote in message
news:7E479E8D-ED7B-4D4F-8500-066C7B3C86CF@.microsoft.com...
> we plan to move our sql server from one place to another place. It's IP
> has
> to been changed, yet the hostname can be kept. I need to access the
> possible
> impact of this move. Our application server query the datababase by server
> name. Apart from changing the DNS, what else I have to pay attention ?

No comments:

Post a Comment