It shouldn't have any negative consequences to the SQL DB, or SQL Server.
However, any application (or connection) that uses the old IP will not
connect. And it may take a short while for the new IP to be picked up and
replicated by AD and the SQL Browser service.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
[quoted text, click to view] "chris" <chris@discussions.microsoft.com> wrote in message
news:B83300E0-BE57-450B-AE5B-45F06C302F43@microsoft.com...
>I need to change the IP address of the server where SQL 2000 is running.
>What
> implications can that have on the SQL DB?