Merge replication over SSL

Hi All.

Hope you can shed some light on this for me. We have set up a merge replication between a SQL Compact SDF database and a SQL 2005 server located in a different domain , the communication is over SSL. If I sync the subscription from the SQl Server 2005 Management Consol the sync works fine however if I try sync from my application the sync fails.

Thanks in advance

Scott McKechnie

Scott, without wanting to sound unhelpful there really isn't enough information here for anyone to help you out (other than to point you at the documentation, which I'm assuming you already have). Can you please provide more information about the error that is being thrown and the configuration you have setup (for example is the SSL cert selfsigned, can you reach the sync url (http://<server>/<virtualdir>/sqlcesa30.dll) etc)

|||Hi,

I think we have a similar problem here. We are trying to perform merge replication between a MS SQL 2005 server and a Mobile Edition database over SSL.

We get an exception "A request to send data to the computer running IIS has failed" when we tried to perform replication via my mobile application.

However, when I tried to access the sqlcesa30.dll via a browser on the device, we encountered no problem.

Is there some code we have to write which we are missing? I am asking this because we started off writing our mobile application with no SSL in mind. So what we have for the replication object parameters are only as follows:

_repl.InternetUrl = @."https://xxx/mobypub/sqlcesa30.dll";

_repl.Publisher = @."xxx";
_repl.PublisherDatabase = @."mobiDB";
_repl.PublisherSecurityMode = SecurityType.NTAuthentication;
_repl.Publication = @."mobiPub";
_repl.Subscriber = @."mobiPub";

What could be causing the problem? Please enlighten. Thanks a lot.

Merge replication over SSL

Hi All.

Hope you can shed some light on this for me. We have set up a merge replication between a SQL Compact SDF database and a SQL 2005 server located in a different domain , the communication is over SSL. If I sync the subscription from the SQl Server 2005 Management Consol the sync works fine however if I try sync from my application the sync fails.

Thanks in advance

Scott McKechnie

Scott, without wanting to sound unhelpful there really isn't enough information here for anyone to help you out (other than to point you at the documentation, which I'm assuming you already have). Can you please provide more information about the error that is being thrown and the configuration you have setup (for example is the SSL cert selfsigned, can you reach the sync url (http://<server>/<virtualdir>/sqlcesa30.dll) etc)

|||Hi,

I think we have a similar problem here. We are trying to perform merge replication between a MS SQL 2005 server and a Mobile Edition database over SSL.

We get an exception "A request to send data to the computer running IIS has failed" when we tried to perform replication via my mobile application.

However, when I tried to access the sqlcesa30.dll via a browser on the device, we encountered no problem.

Is there some code we have to write which we are missing? I am asking this because we started off writing our mobile application with no SSL in mind. So what we have for the replication object parameters are only as follows:

_repl.InternetUrl = @."https://xxx/mobypub/sqlcesa30.dll";

_repl.Publisher = @."xxx";
_repl.PublisherDatabase = @."mobiDB";
_repl.PublisherSecurityMode = SecurityType.NTAuthentication;
_repl.Publication = @."mobiPub";
_repl.Subscriber = @."mobiPub";

What could be causing the problem? Please enlighten. Thanks a lot.

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test

Module

Status

ErrorCode

Version

SQLCERP30.DLL

SUCCESS

0x0

3.0.5300.0

SQLCESA30.DLL

SUCCESS

0x0

3.0.5300.0

Reconciler Test

Reconciler

Status

ErrorCode

9.0 Database Reconciler

SUCCESS

0x0

8.0 Database Reconciler

FAILURE

0x80004005

SQL Server Module Versions

Module

Version

sqloledb.dll

2000.85.1117.0

9.0 replrec.dll

2005.90.3033.0

9.0 replprov.dll

2005.90.3033.0

9.0 msgprox.dll

2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication Issues between SQL Server 2005 (x64) and SQL Server Compact Edition

Hi ppl,

I have installed SQL Server 2005 x64 Enterprise edition with Service Pack 2 on a Windows Server 2003 x64 Standard Edition with Service Pack 2.

Now I have to configure Merge Replication that will work with SQL Server Compact Edition database on Windows Mobile devices.

Distributor and the Publisher are the same server.

IIS 6.0 is installed on the windows server. I have installed the SQL Server Compact Edition Server tools on the server. However the compact edition server tools are only available for 32bit servers and I have also found out from the article http://support.microsoft.com/default.aspx/kb/912430 that you cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS.
So if this is true does that mean I can not use merge replication on 64 bit server? Does that mean I have to get another 32 bit server with 32 bit IIS on it to make this work or is there another work around. Am i missing something here?

Regards
NabeelI think this might solves the issue http://www.pluralsight.com/blogs/jimw/archive/2007/07/06/47932.aspx

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