Mobile Replication

Dear All,

I need to make Sql Server Mobile replication with Sql Server 2005, could any body tell where can I find step by step procedure to make this?

Thanks and Regards

This article will get you started with using replication with SQL Server Mobile

http://msdn2.microsoft.com/en-us/library/ms171801.aspx

Using Merge Replication with SQL Mobile

http://msdn2.microsoft.com/en-us/library/ms172407.aspx

|||

Hi,

I follow the steps mentioned in http://msdn2.microsoft.com/en-us/library/ms171908.aspx

but when I try to run the replication agent I get the following error:

Executed as user: cat-10g\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.

any advise?

Thank s and regards

|||

hi

it worked only after adding the snapshot_agent user to administrators group.

thanks

|||Hi,

I'm a newbe SQL Server developer and had been facing the exact same problem for few days. I could finally start the agent. Thanks ataha.

In addition, I also tried if other user group would work since I didn't want to give full administrator rights to the snapshot_agent. Then I found several SQL Server 2005 related groups are added after SQL Server 2005 was installed. I put snapshot_agent to SQLServer2005SQLAgentUser$computername$instancename and it worked. It's still administrator but I think it's somewhat better than it.

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Thanks again.