Changing a server's TCP/IP address.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mufasa - 29 Jan 2008 18:00 GMT

We are going to be changing our SQL Server's TCP/IP address. Is there
anything I need to do within SQL to make sure it works correctly?

The machine is not doing replication.

TIA - Jeff.

Reply to this Message

Tom Moreau - 29 Jan 2008 18:59 GMT

If it's not in a cluster, then just do the IP change and there's nothing
else to do, outside of restarting SQL Server. If it's a cluster, then:

http://support.microsoft.com/kb/230356

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

We are going to be changing our SQL Server's TCP/IP address. Is there
anything I need to do within SQL to make sure it works correctly?

The machine is not doing replication.

TIA - Jeff.

Reply to this Message

Mufasa - 30 Jan 2008 16:27 GMT

Thanks everybody for your help.

J.

> If it's not in a cluster, then just do the IP change and there's nothing
> else to do, outside of restarting SQL Server. If it's a cluster, then:
[quoted text clipped - 7 lines]
>
> TIA - Jeff.

Reply to this Message

Linchi Shea - 29 Jan 2008 19:03 GMT

If it's not a cluster, none.

Linchi

> We are going to be changing our SQL Server's TCP/IP address. Is there
> anything I need to do within SQL to make sure it works correctly?
>
> The machine is not doing replication.
>
> TIA - Jeff.

Reply to this Message

TheSQLGuru - 29 Jan 2008 20:31 GMT

What about if the server is involved in mirroring or tlog shipping?

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> If it's not a cluster, none.
>
[quoted text clipped - 6 lines]
>>
>> TIA - Jeff.

Reply to this Message

Linchi Shea - 30 Jan 2008 01:49 GMT

I don't believe they depend on the IP address, but I don't have a test
install to verify so I could be wrong. But in any event I certainly hope MS
knows much better than having an app component dependent on IP directly. But
then if an app directly depends on IP, perhaps we should have it failed so it
can fixed.

Linchi

> What about if the server is involved in mirroring or tlog shipping?
>
[quoted text clipped - 8 lines]
> >>
> >> TIA - Jeff.

Reply to this Message