push to subscription in non-trusted domain (Sql 2000)

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!
Sorry, this should have been a reply to a different post.
"William Millett" <william.millett@.altivity.com> wrote in message
news:OHhOC68aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> 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!
>

Public Domain Version Control

Hi,
I am looking for a public domain version control system for my SQL
server project. The public domain price is right, but if it works well
with either Enterprise Manager or Query Analyzer, that would be nice too.
Anyone got any recommendations or links?
JDIf by "public domain" you mean open source:
http://www.nongnu.org/cvs/
I'm not aware of any actual public domain SCM software.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Joe Delphi" <delphi561@.nospam.cox.net> wrote in message
news:ZLwef.74$xu.64@.fed1read01...
> Hi,
> I am looking for a public domain version control system for my SQL
> server project. The public domain price is right, but if it works well
> with either Enterprise Manager or Query Analyzer, that would be nice too.
> Anyone got any recommendations or links?
> JD
>