The IP Address of our SQL server is to be Changed

[MichaelG]

Hello,

Soon, we are going to redesign our servers and their positioning insofar as web access is concerned. The SQL Server will go to a DMZ.

Its IP Address (as well as hostname) is to be changed. Can you offer suggestions about what to be aware of on these two items?

I've been involved in a hostname change befoew (and, it's a pain), but never an IP Address.
Thanks, MichaelG

[MAK]

Here is my article on changing server name. Officially it will be on this site tomorrow

http://www.databasejournal.com/article.php/2194711

[MichaelG]

Hi,

Thanks for the advice & info.

I have two questions on your article:

Should Step 4, lines 7 to 9 read:

use msdb
go
update sysjobs set originating_server ="oldservername"


or, should the line 9 actually read "oldservername", or 'NewServerName'? (Right now it is pointing to the current server.)


Also, the IP address is going to change. Will this procedure take care of that, as well?

Thanks, Michael