Hello,
I am trying to connect a remote sql box to another sql box using pull
subscription. I have the publisher registered in EM. When I try and create a
pull subscription it cannot find the publication unless anonymous
subscribers is on. Did I miss setting a password somewhere? Thanks in
advance.
Jake
Paul,
Sorry I read the instructions wrong. I changed to the SQL server
authentication putting in the replicationserver user and it's password. I
still however do not see the publication on the subscriber via the GUI
unless I mark the publication to allow anonymous. Any ideas?
1. In SQL Enterprise Manager from the Publisher, on the Tools menu, point to
Replication, and then click Configure Publishing, Subscribers, and
Distribution.
Note Because the Subscriber is not configured for the distributor, the
Configure Publishing, Subscribers, and Distribution options are not
available for the Subscriber.
2. Click the Publishers tab.
3. Click the Publisher, and then click the Properties (...) button.
4. Click the General tab, click Using SQL server authentication of this
account to specify that the replication agents use SQL Server
Authentication, and then specify an account that has sufficient permissions
in the publishing database.
"Jake" <rondican@.hotmail.com> wrote in message
news:eNy7p2RtEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I am trying to connect a remote sql box to another sql box using pull
> subscription. I have the publisher registered in EM. When I try and create
> a pull subscription it cannot find the publication unless anonymous
> subscribers is on. Did I miss setting a password somewhere? Thanks in
> advance.
> Jake
>
Friday, March 9, 2012
help with pull subscription
Labels:
box,
connect,
create,
database,
microsoft,
mysql,
oracle,
publisher,
pull,
pullsubscription,
registered,
remote,
server,
sql,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment