Changing a server's TCP/IP address.

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.If it's not a cluster, none.
Linchi
"Mufasa" wrote:
> 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.
>
>|||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
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mufasa" <jb@.nowhere.com> wrote in message
news:eSPpRDqYIHA.4180@.TK2MSFTNGP06.phx.gbl...
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.|||What about if the server is involved in mirroring or tlog shipping?
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:D9BF238C-945E-47BE-B4D9-6B536A8BF9AE@.microsoft.com...
> If it's not a cluster, none.
> Linchi
> "Mufasa" wrote:
>> 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.
>>|||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
"TheSQLGuru" wrote:
> What about if the server is involved in mirroring or tlog shipping?
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:D9BF238C-945E-47BE-B4D9-6B536A8BF9AE@.microsoft.com...
> > If it's not a cluster, none.
> >
> > Linchi
> >
> > "Mufasa" wrote:
> >
> >> 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.
> >>
> >>
> >>
>
>|||Thanks everybody for your help.
J.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u7pBQmqYIHA.4476@.TK2MSFTNGP06.phx.gbl...
> 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
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:eSPpRDqYIHA.4180@.TK2MSFTNGP06.phx.gbl...
> 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.
>
>sql