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
Mobile Replication
Hot Topic
- Syntax Error when using variables in SQL Statement
- External columns vs. output columns?
- Stored Procedure Not Retieving Data
- does not install SQL Query Analyzer
- FTP Task in a SQL Server Agent Scheduled Job - Corrupts Excel file?
- (SSAS2K5) How to perform an Update Cube statement with XMLA ?
- Cannot open database
- xml data source, not sure why i'm losing data
- Error 1418 and Good Basic Setup Guide
- GUIDs using NEWSEQUENTIALID() on SQL Server Mobile
SQL Server
- making two sums in one query
- SQL Server 2005 stored procedures running on Server 2003 machines
- sync_type parameter in subscription
- what is the meaning of "64(error not found)" in sys.transmission_queue
- Coverting Int to DateTime Recommendation?
- Null values
- ODBC Data Source
- Installing SQL Errors - Anyone please read my log file
- Export to excel problem
- help on approach
Mobile Replication
cmille19
hi
it worked only after adding the snapshot_agent user to administrators group.
thanks
pstavroulis
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
hrlevy
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.
Jav74411
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