CHANGING THE REPLICATION SERVER IP

Are you using IP address as the server registration, or
the netbiosname. If it is the latter then there is no
issue. If the former, then I would recommend using
aliases in the client network utility to avoid recreating
the publications.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Thanks for ur reply.
Now In the replication the publisher is in alise name & subscriber is in IP.
I can change the publisher IP but can't the subscriber IP.
I tried to set a test replication with both publisher & subscriber are in
alise name.
But when I set the push subscription, the replication stops & the error
message
comes "The subscription to publication 'databasename' is invalid".
What is the reason for this?
Is it possible to set both pub & sub servers in alise name ?
Thanks,
Soura
"Paul Ibison" wrote:

> Are you using IP address as the server registration, or
> the netbiosname. If it is the latter then there is no
> issue. If the former, then I would recommend using
> aliases in the client network utility to avoid recreating
> the publications.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Yes - on the subscriber for a pull subscription you can
set the publisher in the client network utility. On the
publisher in enterprise manager, you can register the
publisher using an alias. If it is push, you's also
create an alias for the subscriber. Alternatively,
assuming you have trusted domains, you could just not use
the IP addresses at all - the netbiosnames would be more
suitable.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql