"Hilary Cotter" wrote:

> For the pull subscription make sure you are using the sa password of the
> publisher.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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
>
>
>
> "YP" <YP@discussions.microsoft.com> wrote in message
> news:49AB5EE3-5AA5-4E9C-92BB-8652CE51B36D@microsoft.com...
> > Hi
> >
> > I am setting merge replication between 2 PCs in non-domain environment (2
> > PCs in the same wrokgroup)
> >
> > I have used SQL Authentication in both publisher and subscriber and even
> > distributor by clicking Tools>>Replication>> Configuring
> > Publishing,subscriber and distribution. Given them same SQL Authentication
> > of
> > sa and password.
> >
> > I can even register the 2 PCs with each other using the SQL
> > Authentication.
> >
> > I have set my username and password for windows login account to be the
> > same
> > in both PCs
> >
> > However, I have encountered a problem in pull subscription in the
> > subscriber
> > where it say:
> > The process could not connect to Distributor"SERVER". Login failed for
> > user
> > 'sa'. Reason: not associated with a trusted SQL Server connection.
> >
> > What could be wrong? Is there other alternatives in setting up replication
> > in non-domain environment?
> >
>
>