To try out replication I have installed several instances of SQL server on a
single computer. With one default server and one named server merge
replication with pull subscription works fine. When I try to add a pull
subscription to an additional named server however, the publication does not
show in the list.
I tried removing the subscription and publication. Then I added the
publication. This makes the publication visible from both named servers when
I use the pull subscription wizard. But when I finish the wizard to add a
pull subscription to any of the servers, this makes the publication not
appear when I try to create a pull subscription to the other server. If I
only delete the subscription (not the publication), the publication does not
show up from any of the named servers.
The publication is configured to allow anonymous subscriptions.
Additionally, I use the same password for the sa account on all servers, so I
think the publication should be accesible to the login used to connect to the
named servers. Any ideas why the publication does not show up in the pull
subscription wizard?
/Daniel
I still don't know what the problem was, but I worked around it by first
creating a push subscription to the server from which I wanted to create a
pull subscription. This, for some reason, made the publication visible in the
pull subscription wizard.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment