Change IP and name of a server

[crispopa]

Hello everybody,

We have a server running SQL Server 2000 on Windows 2000 Server with SP4.

Because of network changes we will change the IP-Address and the server's name.

How can affect this SQL Server ? Should we re-install SQL Server or will work just fine ?

Regards,
Cristian Popa
IT Analyst

 

[jitter]

For a SQL Server 2000 name change you do not have to reinstall the app.

You will need to use

sp_dropserver <oldservername>

Next use

sp_addserver <newservername>, 'local'

after that you can check it by using

select @@servername

This should return your new name.

That should do it.

You may have to restart the SQL Server service but I am not totally sure on that.

Hope this helps.

Jitter

 

[mrdenny]

You shouldn't need to restart after changing the name in SQL, however you should do this just before you change the name of the actualy server.

As for changing the IP address. After the IP has been changed, stop and restart the SQL Services and you should be fine.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[miq]

HI,

For simple network accessability
Ensure that windows 2000/2003/NT machine name matches with the name of sqlsever.


right from BOL

If the Windows NT 4.0 or Windows 2000 name was changed, use sp_dropserver and sp_addserver to match it with the SQL Server computer name.

The local definition takes effect only after the server is shut down and restarted

B.R,
miq