Monday, February 20, 2012

merge replication and domains

Does SQL2K needs the publisher and subscriber to be in same domain?
Can we configure merge replication between two stand-alone servers?
it does not, you can replicate from two stand alone server. What you should
do is create a local administrator account with the same name and password
on both servers and use this account for the SQL Server and SQL Server Agent
accounts.
--
Hilary Cotter
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
"ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
> Does SQL2K needs the publisher and subscriber to be in same domain?
> Can we configure merge replication between two stand-alone servers?
|||You might want to have a look at these articles:
http://www.replicationanswers.com/InternetArticle.asp
http://support.microsoft.com/?id=321822
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I have done that..but when i create the subscriber i get the message..process
could not deliver the snapshot to the subscriber..
"Hilary Cotter" wrote:

> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> Hilary Cotter
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>
|||i did that but it was not working. Only after giving the $ share access to
the snapshot folder it started working.
"Hilary Cotter" wrote:

> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> Hilary Cotter
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>

No comments:

Post a Comment