Re: merge Replication with a Notebook not in domain

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: merge Replication with a Notebook not in domain
    ... Director of Text Mining and Database Strategy ... 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: 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: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
    ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
    (microsoft.public.sqlserver.replication)
  • Re: High Availability
    ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
    (microsoft.public.sqlserver.clustering)
  • 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)