all groups > sql server replication > july 2007 >
You're in the

sql server replication

group:

Replication Options


Replication Options Jas
7/19/2007 12:30:01 PM
sql server replication: Hi, we have an SQL Server on Domain A that need to replicate to a client on
Domain B. There is no trust between the two domains. What are the options
we have to have a replication setup between the 2 SQL?

RE: Replication Options Jas
7/19/2007 12:40:01 PM
I forgot to mention but the main server is using Standard 2005 and client is
using Workgroup 2005

[quoted text, click to view]
Re: Replication Options Jas
7/20/2007 5:50:00 AM
Is replication via FTP still working in 2005 version? Because it maybe a
solution...

[quoted text, click to view]
Re: Replication Options Hilary Cotter
7/20/2007 7:05:40 AM
replicating between member servers in a work group is difficult as there is
a 5 or 10 connection limitation per machine.

basically you can use SQL authentication, and set your SQL Server agent
accounts up on both machines to run under an account which has the same name
and password on both the publisher and subscriber.

Then ensure this account has read and list files and folders rights on the
directory which underlies your snapshot share.

--
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
[quoted text, click to view]

Re: Replication Options Hilary Cotter
7/21/2007 12:00:00 AM
yes!

--
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
[quoted text, click to view]

Re: Replication Options Jas
7/24/2007 4:58:00 AM
Is there any documentation on how to setup a replication using FTP in SQL
Server 2005?


[quoted text, click to view]
AddThis Social Bookmark Button