Groups | Blog | Home
all groups > sql server replication > march 2007 >

sql server replication : push to subscription in non-trusted domain (Sql 2000)


William Millett
3/21/2007 10:35:06 AM
Thanks for your response.
I don't know how to do pass-through authentication across domain
(particularly using SQL2k replication), I thought that would require a
trusted account on both sides.
I have been trying using the sql account and although I can connect to the
subscriber using the account from query tools and em, I keep receiving an
error when my distribution agent tries to connect: "The process could not
connect to Subscriber 'subscriptionservername'"
I've tried it before and after manipulating the Replication Distributor
authentication arguments and the Subscriber is already setup on the
Distributor to use sql authentication (I've reset this login and pwd at
least once for each trial, I'm reasonable sure it is not mistyped). Same
errant response always.
I even once tried populating the data 1st (in case the snapshot folder was
the only issue) but I did not try to populate the MS* subscription tables
which I figured would blow up anyway, but it couldn't connect so I got the
same response.
Got any ideas? Am I missing something?
Please ... Help!

William Millett
3/21/2007 11:24:08 AM
Sorry, this should have been a reply to a different post.

[quoted text, click to view]

AddThis Social Bookmark Button