Sunday, March 25, 2012

Changing the IP address of a SQL 2000 SP3a server

What is the proper procedure for changing the IP address of a SQL 2000
Server?
Are there any gotchas, or is it as straight forward as just changing the
IP address?
Hi,
Rob Gordon
No procedures to follow to change the IP address. You can do straight away.
Nothing will happen.
"Rob Gordon" wrote:

> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
>
|||Only impact will be if any clients/programs, etc. find it via the IP address
instead of the server name.. or is that changing, also.
Regards,
Hank Arnold
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
|||You will need to stop/start the service after the address change. SQL binds
to whatever IP addresses exist at service startup time.
If you are running a cluster, that is an entirely different proposition.
You should repost the question in the .clustering newsgroup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rob Gordon" <Robert.Gordon@.nospam.yosemitetech.com> wrote in message
news:ufFgHjCBFHA.3824@.TK2MSFTNGP10.phx.gbl...
> What is the proper procedure for changing the IP address of a SQL 2000
> Server?
> Are there any gotchas, or is it as straight forward as just changing the
> IP address?
|||On Wed, 26 Jan 2005 20:26:03 -0800, Rob Gordon
<Robert.Gordon@.nospam.yosemitetech.com> wrote:

>What is the proper procedure for changing the IP address of a SQL 2000
>Server?
Change the IP.

>Are there any gotchas, or is it as straight forward as just changing the
>IP address?
Remember to update any DNS records you may need to, and if a client
connects via the IP address, it will need changing as well.
Jeff

No comments:

Post a Comment