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

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

Merge Replication error while applying Snapshot

Hi,

i am getting the below error while applying running the Synchronization agent for the Subscriber. I have created replication topology with one central server and one subscriber. Here central server has windows server 2003 and subscriber has windows XP. Both are having SQL server 2005. After creating the merge subscriber, i am runnnig the Synchronization agent manually for the first time. While running that i am getting below error. Anybody aware of this error.

2006-06-24 00:26:00.175 Applying the snapshot to the Subscriber
2006-06-24 00:26:02.722 The schema script 'D_NUM_7.sch' could not be propagated to the subscriber.
2006-06-24 00:26:02.784 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'D_NUM_7.sch' could not be propagated to the subscriber.
2006-06-24 00:26:02.816 Category:AGENT
Source: WMBT-07
Number: 0
Message: The process could not read file '\\WMBT-01\repldata\unc\LTR-IN001_TEST_PUB\20060624034804\D_NUM_7.sch' due to OS error 1265.
2006-06-24 00:26:02.831 Category:OS
Source:
Number: 1265
Message: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.

does the account under which the agent is running under have access to the share?|||

Greg,

Thanks for giving me the response...

Actually i am not clear about the Account... How to see the Account under which Agent is running?

I still dont understand where we are linking the Account and Agent.

Can you help on this ?

Thanks in advance.

|||

Greg,

Are you asking the about Agent in Central Server or in the Subscriber.

Thanks.

|||When you setup replication, you are asked to specify security credentials for the Snapshot agent, Log Reader Agent, Distribution Agent, Merge Agent, Queued Reader Agent. (Which agents you need to specify credentials for vary based on the method of replication.) The account that you specified for either the distribution agent (for snapshot or transactional replication) or the merge agent (for merge replication) needs to have the authority to access the snapshot folder in order for this to work successfully.|||

There are two places you may need to check.

1. Since snapshot files are saved under distributor, in your case, it may be the central server, which is both publisher and distributor, so make sure your publication snapshot files are saved under an alternate folder, UNC folder, which can be accessed by merge agent running on the subscriber.

2. Check merge agent account which is used to connect to distributor, it must have read permissions on the snapshot share. You can check it through open merge agent job properties.

Hope the above will be helpful.

Thanks

Yunjing

|||

Hi All,

Thanks for all you replies. I solved the problem i faced.

Normally when i create a Subscriber for Account under which Merge Agent will run i used to give as "Run Under SQL Server Agent Service Account" . It was working for me all these days. In all the machines where I created Replication was having windows XP. But when i was trying to create the Replication with systems with windows Server 2003, i have got the above said error.

To solve that error i have created one windows account in the Publisher and Subscriber with same name and same password. Then while creating the Publisher and Subscriber I was using this windows account as process Account for all the Agents. After that it was working fine. Here the windows account has to be there is both Publisher and Subscriber with same name and same Password. It was working for me. I have added that windows account as part of Administrator Group.

Thanks,

Thams.

Merge Replication error while applying Snapshot

Hi,

i am getting the below error while applying running the Synchronization agent for the Subscriber. I have created replication topology with one central server and one subscriber. Here central server has windows server 2003 and subscriber has windows XP. Both are having SQL server 2005. After creating the merge subscriber, i am runnnig the Synchronization agent manually for the first time. While running that i am getting below error. Anybody aware of this error.

2006-06-24 00:26:00.175 Applying the snapshot to the Subscriber
2006-06-24 00:26:02.722 The schema script 'D_NUM_7.sch' could not be propagated to the subscriber.
2006-06-24 00:26:02.784 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'D_NUM_7.sch' could not be propagated to the subscriber.
2006-06-24 00:26:02.816 Category:AGENT
Source: WMBT-07
Number: 0
Message: The process could not read file '\\WMBT-01\repldata\unc\LTR-IN001_TEST_PUB\20060624034804\D_NUM_7.sch' due to OS error 1265.
2006-06-24 00:26:02.831 Category:OS
Source:
Number: 1265
Message: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.

does the account under which the agent is running under have access to the share?|||

Greg,

Thanks for giving me the response...

Actually i am not clear about the Account... How to see the Account under which Agent is running?

I still dont understand where we are linking the Account and Agent.

Can you help on this ?

Thanks in advance.

|||

Greg,

Are you asking the about Agent in Central Server or in the Subscriber.

Thanks.

|||When you setup replication, you are asked to specify security credentials for the Snapshot agent, Log Reader Agent, Distribution Agent, Merge Agent, Queued Reader Agent. (Which agents you need to specify credentials for vary based on the method of replication.) The account that you specified for either the distribution agent (for snapshot or transactional replication) or the merge agent (for merge replication) needs to have the authority to access the snapshot folder in order for this to work successfully.|||

There are two places you may need to check.

1. Since snapshot files are saved under distributor, in your case, it may be the central server, which is both publisher and distributor, so make sure your publication snapshot files are saved under an alternate folder, UNC folder, which can be accessed by merge agent running on the subscriber.

2. Check merge agent account which is used to connect to distributor, it must have read permissions on the snapshot share. You can check it through open merge agent job properties.

Hope the above will be helpful.

Thanks

Yunjing

|||

Hi All,

Thanks for all you replies. I solved the problem i faced.

Normally when i create a Subscriber for Account under which Merge Agent will run i used to give as "Run Under SQL Server Agent Service Account" . It was working for me all these days. In all the machines where I created Replication was having windows XP. But when i was trying to create the Replication with systems with windows Server 2003, i have got the above said error.

To solve that error i have created one windows account in the Publisher and Subscriber with same name and same password. Then while creating the Publisher and Subscriber I was using this windows account as process Account for all the Agents. After that it was working fine. Here the windows account has to be there is both Publisher and Subscriber with same name and same Password. It was working for me. I have added that windows account as part of Administrator Group.

Thanks,

Thams.