Sqlserver change IP address Moving to diff BOX

[koradas]

Hai,
We have a sqlserver box and now we are moving all the databases to different server/box which will have different IP address etc.
What all the changes do we need to make and where do we do...at system level and database level, users are connecting through web.
We are having sqlserver 2000.
Please provide me with info .....

Thanks
krishna

 

[Corran007]

are you changing the name of the server?

if you are connecting everyone via the database server name(which is by default the machine name) then if you rename the box to the old name, you shouldnt need to change anything even if the ip changes. If you are connenting via ip, you will have to change it. This includes any odbc that connect via ip or any specific alias via client network utility.

If so, there are several posts on migrating servers here.