"Jon Naile" <jnail@chinet.com> wrote in message
news:c10b01c40eb2$9417c5d0$a001280a@phx.gbl...
>
>
> Is there a way to setup two separate subscribing databases
> on one machine that each subscribe to two separate
> publishing databases on one SQL server.
>
> It appears that the server can not differentiate between
> the subscribers, since they are coming from the same port.
> Is there an Alternative one can explore in order
> to persue having two separate synchronizations going on?
>
> Thanks
>
> Jon R.

>-----Original Message-----
>Yes this is entirely possible. Consider 2 machines, one
called publisher one
>called subscriber.
>
>Publisher has two databases on it, pub1 and pub2.
>
>Subscriber has two databases on it, sub1 and sub2.
>
>You can create a publication on Publisher in the pub1
database, and sub1 and
>sub2 databases on Subscriber can subscribe to it.
>You can create a publication on Publisher in the pub2
database, and sub1 and
>sub2 databases on Subscriber can subscribe to it.
>
>Or you could enter a third server Publisher1 with two
databases on it, pub1
>and pub2.
>
>You can create a publication on Publisher1 in the pub1
database, and sub1
>and sub2 databases on Subscriber can subscribe to it.
>You can create a publication on Publisher1 in the pub2
database, and sub1
>and sub2 databases on Subscriber can subscribe to it.
>
>Replication is very flexible this way.
>
>
>"Jon Naile" <jnail@chinet.com> wrote in message
>news:c10b01c40eb2$9417c5d0$a001280a@phx.gbl...
>>
>>
>> Is there a way to setup two separate subscribing
databases
>> on one machine that each subscribe to two separate
>> publishing databases on one SQL server.
>>
>> It appears that the server can not differentiate between
>> the subscribers, since they are coming from the same
port.
>> Is there an Alternative one can explore in order
>> to persue having two separate synchronizations going on?
>>
>> Thanks
>>
>> Jon R.
>
>
>.