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 ***

No comments:

Post a Comment