Re: merge Replication with a Notebook not in domain

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: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (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)
  • Re: Oracle to SQL Replication.
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: replication to sql server by activeX
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... on another machine and the batch file is working fine. ...
    (microsoft.public.sqlserver.replication)
  • Re: Help in setting up SQL Server 2005 Replication
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... about subscription. ... "Run under the SQL Server Agent's Account". ...
    (microsoft.public.sqlserver.replication)