Merge Replication on Windows XP

Hi

Is it possible to create Merge Replication between two server running on Windows XP(SP2).

Why i ask this, as i am trying to do so, but got the error

"The process could not connect to Distributor",

As i already change the login for these two services for "local system" to with Administrative permisstions, but noting seem good for me.. getting the same error.)

when i googling around this, what i find, i need the Domain Account to login to as the services (SQL SERVER & SQL AGENT) one. is it so i need the domain controler for the this ?

How can i create a domain account, without PDC (primary domain controller).

or

so help me out, is there any boby who setup the same?

if so help me.... or ..... any other solution or hint to do so

Regards,

Thanks.

Gurpreet S. Gill

yes replication does work on XP, check your firewall settings on the machines. localsystem account should work, but you may lose some secuerity functionality.|||

Greg Y--

Thanks.

i had checked the Firewall settings, on the both of the machines these are already disabled, as i dont need much security, so i can go for that.

Now the point is, to who should i set the logon for the services, i mean the user, i already set it to the Administrator but doesnt work for me, what could be the cause, as i am continue getting the same error....

The process could not connect to Distributor 'server name'

Regads,

Thanks

Gurpreet S. Gill

|||

Hi all

Finally i am able to solve the problem, now my Merge Replication works very fine.

I would like to thank all who help me.

now i want to share that what i made

1) Create a Distributor & publisher one SERVER 1

2) Create the Subscriber on the SERVER 2.

point to note

i) i am on XP(with SP2) & SQL-Server 2005

ii) Default Snapshort Folder path at SERVER 1 must be in UNC (this is where i was making mistake)

iii) at theSERVER 2, the Subscription Properties page

Security Setting as as follows(number 6 in list)

a) Agent process accont

Account name : SERVER2\Administrator

Password :*********

b) Distributor Connection : SQL Server Authentication(sa)

c) Publisher Connection : SQL Server Authentication(sa)

iv) Both Machines having same user name & password for the SQL Server as well as the Machine login(Administrator)

if somebody still have any problem, then do post in this as a reply

Thanks

Regards

Gurpreet S. Gill