Problem in SQL server database synchroniztion with sql ce

hi all...

I've been facing a problem in synchronizing sql server database and sql ce. I have published the northwind the database set everything up according to the article in http://www.msdn.microsoft.com/SQL/SQ...s/default.aspx. I am runnin the code given along with the article only.

when i run the application errors are given as in the attached images. I also see snapshots created in the sql server bt with errors. I've attached the error screens in case they might be useful.

Could some one help me out????


NISLM

it sounds to me as there is a problem with permissions in IIS or SSCE directory.

I have came across these errors before and solved it with a change of permissions.

ya... the problem is SQL Server Agent should not run using the windows user who is being logged on. Another user having the permission to run SQL Server Agent should be used to run the Agent.