Dear support,
I am working on my graduation project that has a wide section of PC Pocket application to merge data between the SQL Mobile Edition and the SQL Server 2005. So, i had done most of the steps mentioned in the Books Online for the SQL Mobile Edition, till i had reached the step of creating a subscription for the Mobile Database, it is known that at the end of this step there would be a code generated in order to use it in developing the application and after clicking finish the wizard will start Synchronization. Here this step fails with a message informing me that the snapshot agent is not started yet or the publisher didnt generate the snapshot yet !!
So looking forward to getting your advice soonly!
Thank you for your attention,
Kindly Regards;
Need help regarding Replication between SQL Server 2005 and SQL Server Mobie Edition!
trinta
I appreciate your reply so much and i will be working on it soonly after this clearification if possible. I am using Microsoft SQL Server 2005 and when i want to grant permissions on the database i do the following :
I connect to the Database engine, expand security, right click on Login, choose New Login, i type in the Login Name textbox {mycomputername}\iusr_mycomputername
then i choose from the combo box of the default database the database i am working on, after that i click on the navigation pane to the User Mapping and i select the database i need. then i click ok . This is what i read in the Books Online, if there is any mistake or misunderstanding from my side, please i'll be glad to inform me soonly with the right steps to be done in granting the permission for the anonymous authentication of both the database and the publication.
Thank you again for your attention,
Best Regards;
Matt Finucane
The SQL Agent on the server must generate an initial snapshot of your publication before you can perform merge replication. In SS2005 Management Studio, you can right click on the publication and choose View Snapshot Agent Status. If it is erring out or hasn't completed successfully, be sure you have granted permissions on both the database that contains your published articles and on the publication itself to the anonymous IIS user account (IUSR_{yourservername}) as database reader and database writer. (I am assuming you are using anonymous authentication given the nature of your project).
Once you get a good snapshot created, you should test your path from device or emulator to the virtual directory containing the SQL Mobile server tools. From Pocket Internet Explorer, see what you get by entering http://{server name or IP address}/{virt dir name}/sqlcesa30.dll.
-Darren