Changing IP ADDRESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex P. - 25 May 2005 17:00 GMT

Hi All,
I have a SqlServer2000 on a windows2000 server machine. I need to change the
IP server address (only the IP. not the server name).

I know that clients that will try to connect using ip address will need to
change it, BUT, the sql server needs anything else respect to the
configuration? can i change the IP Address without problems??

can i find documentation about this??

Thanks for your help.

Att. Alex

Reply to this Message

Keith Kratochvil - 25 May 2005 17:04 GMT

No, nothing else needs to change.

Signature

Keith

> Hi All,
> I have a SqlServer2000 on a windows2000 server machine. I need to change
[quoted text clipped - 10 lines]
>
> Att. Alex

Reply to this Message

Hari Prasad - 25 May 2005 20:11 GMT

Hi,

If any client configured a Alias using CLient network utility using the TCP
IP protocol then you need chage the Ipaddress with new one.

Thanks
Hari
SQL Server MVP

> Hi All,
> I have a SqlServer2000 on a windows2000 server machine. I need to change
[quoted text clipped - 10 lines]
>
> Att. Alex

Reply to this Message

Geoff N. Hiten - 25 May 2005 20:50 GMT

You will need to stop and restart the SQL Server service after the IP
address change. SQL Server binds to all IP addresses at service startup and
does not change later.

Geoff N. Hiten
Microsoft SQL Server MVP

> Hi All,
> I have a SqlServer2000 on a windows2000 server machine. I need to change
[quoted text clipped - 10 lines]
>
> Att. Alex

Reply to this Message