Saturday, February 25, 2012

registration and Replicatons

Is registration of the subscriber required to configure replications.
I am configuring replications over the internet using a VPN connection
and do not want the Publisher/Distributor (Publisher and Distributor
are the same) to have the Subscriber registered. I know you can add a
subscriber using the system stored procedure but I was wondering if
registration of the subscriber was a requirement to perform
replication.
Thank you in advance for your help.
It is required.
You must register the servers in your hosts file, client configuration utility, and EM. Then you must enable your subscriber using SQL Server authentication.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Gent" wrote:

> Is registration of the subscriber required to configure replications.
> I am configuring replications over the internet using a VPN connection
> and do not want the Publisher/Distributor (Publisher and Distributor
> are the same) to have the Subscriber registered. I know you can add a
> subscriber using the system stored procedure but I was wondering if
> registration of the subscriber was a requirement to perform
> replication.
> Thank you in advance for your help.
>

No comments:

Post a Comment