Need to change IP address of server

[hazly]

I don't know much about MS SQL-Server. I'm having SQL server 2000 and
going to change IP address of the server. What need to be done?

[Simon Hayes]

"hazly" <s_*****@oritech.com.my> wrote in message
news:cc**************************@posting.google.c om...

I don't know much about MS SQL-Server. I'm having SQL server 2000 and
going to change IP address of the server. What need to be done?

If you're only changing the IP address and nothing else (eg. server name,
domain), and you don't have a cluster, then you shouldn't have any problems,
as long as your name resolution service is updated (ie. DNS). This KB
article covers changing the IP address of a clustered installation:

http://support.microsoft.com/default...b;en-us;244980

Simon