Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : Can you setup replication on an XP?


Bob Bartel
5/19/2006 1:26:15 PM
I have a desktop XP Professional, and a Laptop using XP Professional. I
have a SQL database I want to Merge Replacate to-from.

Can it be done? Or do you have to have SQL Server 2000/2003?

The reason I'm asking is that I try to setup replication, and it keeps
failing because of Access Rights issues and I am wondering if you have to
setup a domain before it will work.

Bob Bartel

Hilary Cotter
5/19/2006 6:48:25 PM
Its not clear to me that you have SQL Server installed. Do you?

Replication is problematic on workstations which are part of a work group as
opposed to a domain due to the 5 user connection limit. To get it to work
issue a net stop workstation, and then a net start workstation and
immediately try to run your replication job.

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

[quoted text, click to view]

AddThis Social Bookmark Button