Re: merge Replication with a Notebook not in domain

Hi

I have encountered the same problem in pull subscription too in workgroup
environment.
It say: The process could not connect to Distributor"SERVER". Login failed
for user 'sa'. Reason: not associated with a trusted SQL Server connection.

I have set up all SQL Server login in both publisher and subscriber.Also
same windows login user and password for both PC.And have edit the setting in
Windows Synchronization from "By browsing the active directory from
publication" to "By specifying the publication and subscription information
manually" in subscriber.

But was still encountering the same error.


"Hilary Cotter" wrote:

Set the administrator account on your local machine to use the same
password.

To see Windows Synchronization Manager go to Start, Programs, Accessories,
and Synchronize.

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



"Bonato Pierantonio" <pbonato@xxxxxxxxxxxx> wrote in message
news:%23jhoQ7vYGHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
Sorry my few experience in that... but what is "Windows Synchronization
Manager"
I my publisher I use MyDomain\Administrator that I Cannot use in the
subscriber (it is on workgroup and not in domain...)

Thanks


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> ha scritto nel messaggio
news:%2381Es8sYGHA.3516@xxxxxxxxxxxxxxxxxxxxxxx
Use pull replication, possibly managed by Windows Synchronization
Manager, and change your SQL Server agent account on your subscriber to
match that on your 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



"Bonato Pierantonio" <pbonato@xxxxxxxxxxxx> wrote in message
news:e9s$yUsYGHA.4836@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,
I have a problem, I have a database in a SQL 2000 SRV that I need to
replicate with a Notebook where is installed MSDE 2000.
The Notebook is non link to the Domain but it use a Workgroup Access to
browse the LAN.
When I try to use a PULL replication it give me an access denied error,
and I cannot use the Administrator to start the SQLAgent service (it is
out the domain)
So I need to use the PUSH replication from the main SQL Server to
replicate. The proble is that the notebook is outside for 3days at week
and each hour the main SQL Server try to connect with the notebook and
give me an alert.

How can I solve this problem?

Thanks to all
Bonato Pierantonio, MCSD









.

Relevant Pages

  • Re: Server to server Replication
    ... Replicated data is mostly read-only at the Subscriber. ... You need updates to be propagated on a transaction basis, ... Use snapshot replication or transactional replication with immediate ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with merge replication
    ... subscriber changes before the new snapshot comes down. ... Looking for a SQL Server replication book? ... I use merge replication with windows CE clients and SQL Server 2005. ... If someone collects data in an existing table on the client (the ...
    (microsoft.public.sqlserver.replication)
  • RE: SQL Server Errorlog login Failure
    ... the login error. ... If your replication agents are proper, ... agent startup account etc to resolve it. ... ||I have an Windows account that runs all my SQL Server ...
    (microsoft.public.sqlserver.replication)
  • NOT FOR REPLICATION clause in triggers that are replicated to subscribers are fired twice in both pu
    ... transactional replication trought VPN with updatable subscriptions to SQL ... of then marked as NOT FOR REPLICATION and copied along to the subscriber) so ... This is true for SQL Server 2000 either the insertion/update/deletion ... happens on the publisher or the subscriber: Ie, if the user is connected to ...
    (microsoft.public.sqlserver.replication)
  • Re: merge Replication with a Notebook not in domain
    ... subscriber ... Looking for a SQL Server replication book? ... The Notebook is non link to the Domain but it use a Workgroup Access to ...
    (microsoft.public.sqlserver.replication)
Loading