Showing posts with label thesubscriber. Show all posts
Showing posts with label thesubscriber. Show all posts

Monday, March 12, 2012

pull subscription

I cannot get a pull subscription to work. I have created my publication
to allow anynonomous. The client is a registered subscriber. On the
subscriber I created the pull subscription always specifying the SQL
server authentication and entering the login/password.
I have enabled loggin, but I can't find where it says this is the
problem.
The error is:
The process could not deliver the snapshot to the subscriber. The step
failed.
I sure would like more information. I am leaning towards a security
issue, but the SQL authentication login and password are also setup on
the server as a user name/password with admin rights.
THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
THanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
On your publisher connect to your publisher in EM, then go to tools,
replication, configure distributor, publishers, subscribers, click on the
subscriber tab, locate your subscriber, click on the browse button the right
of your subscriber, and in the SQL login enter the sa account and password
of the Publisher. Restart your pull agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darin" <darin_nospam@.nospamever> wrote in message
news:uA7gFbUtFHA.2912@.TK2MSFTNGP09.phx.gbl...
> I cannot get a pull subscription to work. I have created my publication
> to allow anynonomous. The client is a registered subscriber. On the
> subscriber I created the pull subscription always specifying the SQL
> server authentication and entering the login/password.
> I have enabled loggin, but I can't find where it says this is the
> problem.
> The error is:
> The process could not deliver the snapshot to the subscriber. The step
> failed.
> I sure would like more information. I am leaning towards a security
> issue, but the SQL authentication login and password are also setup on
> the server as a user name/password with admin rights.
> THe server is Win2000 running SQL 2000. Client is XP Pro running MSDE.
> THanks.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***

Saturday, February 25, 2012

Publication takes record off subscriber

When I synch my subscriber back to my maste. A record I created on the
subscriber is now on the master but it is not also on the subscriber
like it should be. Any ideas? Everything seems to be in order.
Never mind. Those above me decided to add filters without telling me.
Thanks for taking the time to read this.
On Thu, 28 Apr 2005 16:09:14 -0600, Shane Lim <gslim@.blizzardice.com>
wrote:

>When I synch my subscriber back to my maste. A record I created on the
>subscriber is now on the master but it is not also on the subscriber
>like it should be. Any ideas? Everything seems to be in order.