Replication Options

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?
Thanks in advance for any answer!!
I forgot to mention but the main server is using Standard 2005 and client is
using Workgroup 2005
"Jas" wrote:

> 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?
> Thanks in advance for any answer!!
|||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
"Jas" <Jas@.discussions.microsoft.com> wrote in message
news:8DEC33DF-A653-43AD-A507-D0693FA031E6@.microsoft.com...
> 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?
> Thanks in advance for any answer!!
|||Is replication via FTP still working in 2005 version? Because it maybe a
solution...
"Hilary Cotter" wrote:

> 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
> "Jas" <Jas@.discussions.microsoft.com> wrote in message
> news:8DEC33DF-A653-43AD-A507-D0693FA031E6@.microsoft.com...
>
>
|||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
"Jas" <Jas@.discussions.microsoft.com> wrote in message
news:89544D88-6314-42CC-893E-D24D0B4789CE@.microsoft.com...[vbcol=seagreen]
> Is replication via FTP still working in 2005 version? Because it maybe a
> solution...
> "Hilary Cotter" wrote:
|||Is there any documentation on how to setup a replication using FTP in SQL
Server 2005?
"Hilary Cotter" wrote:

> 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
> "Jas" <Jas@.discussions.microsoft.com> wrote in message
> news:89544D88-6314-42CC-893E-D24D0B4789CE@.microsoft.com...
>
>