Showing posts with label stand-alone. Show all posts
Showing posts with label stand-alone. Show all posts

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...
>
>