Merge Replication failure message

I'm getting the error message below when trying to synchronise a sql compact database to a sql server 2005 db. Can anyone suggest a reason for this?

RDA works fine, permissions look ok. I've run process monitor and can see the IN/OUT files being created, no ACCESS DENIED messages etc. help!

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed. Try again.
HRESULT 0x80045901 (29045)

The merge process could not initialize the message file from Subscriber 'D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.IN:D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.OUT'.
HRESULT 0x80045901 (0)

The operation could not be completed.

- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

Bill, the SQL Server Reconciler is unfortunately one of the less stable parts (IMHO) of merge replication and there seems to be a number of things that can go wrong with it (and the errors are still not that useful). This said, there are a couple of things I would look for. Firstly, are you partitioning your data with filters - each partition will create its own snapshot which takes time, during which repeated syncs will fail - you might want to try a simple publication first. The other thing I would look at is the snapshot agent status (right-click your publication and select View Snapshot Agent Status. From this dialog you can kick off and monitor the creation of snapshots.

Hope this helps

|||Hi Nick,
Thanks for response. I'm not using any filters, so the "simple" :) merge is not working. Also checked the agent status but its just showing me the same error message.

I've looked on google groups since and there are few people who had the same issues in previous versions of CE. Looks like the error code is a "general security failure". So I'm going to over this area once again but i'm not hopeful.
bill.|||Question: Can you access the sync url (eg http://<server>/<virtualdir>/sqlcesa30.dll)? This should return the text string "SQL Server Mobile Server Agent 3.0"|||Accessing the dll works fine.

Will come back to this and try again on a clean machine but I'll have to leave this for now. Thanks for your help.|||

HI Nick, I hope you can help me with my errors....

Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)

The remote server "TOSHIBA-USER" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
HRESULT 0x00003700 (0)

{call sp_helpdistpublisher (N'TOSHIBA-USER') }
HRESULT 0x00000000 (0)

You do not have the required permissions to complete the operation.
HRESULT 0x0000372E (0)

The operation could not be completed.

I have no idea how to solve all this and hope that you can advice me on this...

Your help are sincerely appreciated, thk you..

|||It seems that the account used for SQL Server access does not have the required permissions. Please test with a sa/administrator account to determine that this might be the problem.|||Hi Erik thanks for the reply,
I had the SQL server 2005 reinstall followed by I had this new error HResult 0x80004005 (29061).

Can I just check with do you know how to solve this error:

SQLCeException was unhandled
HResult 2147217865
Native error 0|||

Information about this error is available at: http://msdn2.microsoft.com/en-us/library/ms172357.aspx

Your SQL Server name/credentials are not working:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the computer running SQL Server, or the password is incorrect.

|||THks for the information, I am a newbie to SQL do you have any idea how to solve this part?

Many thanks, appreciated it