Wednesday, March 7, 2012

Only see my local server in my parter server list

Hello,
I'm trying to enable Subscribers to synchronize with alternate publisher,
I go to the properties of the publication and then to sync partners, then I
enable the Allow Subscribers to synchronize with other partners than the
Publisher from which the subscription was created, but the only server that
I see is my local server. Do I have to do something else in order to make
my two SQL servers partners?
Thank you very much in advance,
Marlene A. Roman
Register the other server in Enterprise Manager.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||you also have to run sp_addmergealternatepublisher on your subscriber and
configure your merge publication to allow synchronization with alternate
sync partners by setting @.allow_synctoalternate to true on
sp_addmergepublication.
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:uG5KSPmLEHA.4052@.TK2MSFTNGP11.phx.gbl...
> Register the other server in Enterprise Manager.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>

No comments:

Post a Comment