473,231 Members | 2,014 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SqlCE Synchronization Issue: Native Error 29006, The process could not deliver the snapshot to the Subscriber

Rod
I orginally posted this to microsoft.public.sqlserver.ce but had not
received any responses.

I have a CF.NET application (C#) with a SqlCE database. We had
originally planned to use SQL Authentication to replicate with the
publication and indeed had SQL Authentication working flawlessly. Then
our client asked us to use Windows Authentication instead.

For incremental changes, Windows authentication works fine. When
trying to do the initial synchronization where the application receives
the snapshot database from the publishing database, there is trouble.
I have tested this in the PPC 2002 and 2003 emulators and on an
actually PPC device as well. I get the following error:

A call to SQL Server Reconciler failed. [,,,,,],
Source=Microsoft SQL Server 2000 Windows CE Edition,
NativeError=29006,HResult=-2147467259

The process could not deliver the snapshot to the Subscriber.,
Source=Merge Replication Provider,
NativeError=0,HResult=-2147201001

Here is difference in my code between Windows and SQL Authentication:
#if SQLAUTHENTICATION
repl.PublisherLogin = "MyLogin"; // publisher Login;
repl.PublisherPassword = "MyPassword"; // publisher Password;
repl.PublisherSecurityMode =
System.Data.SqlServerCe.SecurityType.DBAuthenticat ion;
#else
repl.PublisherSecurityMode =
System.Data.SqlServerCe.SecurityType.NTAuthenticat ion;
#endif

As far as I know, I have properly configured the snapshot IIS folder
with the correct permissions for IIS_MachineName (for anonymous-Sql
Authentication) and also with the domain users for Windows
Authentication. The domain users are also in the Publication Access
List.

The bottom line is that in for Windows Authentication I am not able to
receive the snapshot from the publishing database on the first
synchronization. However, I am able to do incremental synchronization
through Windows Authentication. And I have no problems with SQL
Authenication (via the anonymous user).

I am stumped by the "process could not deliver the snapshot to the
Subscriber" error. Have any of you encountered this situation before,
and if so, how did you resolve it?

Note: SQL Server and the IIS folder for synchronization are all on the
same machine.

Thanks,
Rod Early

Jan 11 '06 #1
0 3463

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Karthik | last post by:
Hi, We have setup a publisher and a distributor in SQL 2000 running SP3. Alongwith this we have setup a merge replication agent and its running successfully inside the same network. I allow...
0
by: Sridhar G | last post by:
Hi, I have implemented Snapshot replication on my database server. The publisher, distributor and the subscriber are in the same machine. There is a database 'X' that gets replicated every...
0
by: Mehek | last post by:
I tried setting up a Merge Replication between a MSDE (Pull Subscription) and Sql Server 2000 (Publisher) and got the following error: The process could not enumerate changes at the...
2
by: Alan F. | last post by:
I am setting up a combination of transactional and merge replication on a very large database and do not want to apply the initial snapshot since this would take to long. I am doing this with...
2
by: Boris Fortes | last post by:
I need to unhook event receiver as result of native C++ event. It unhooks successfully, but __raise does not return and throws access violation. Visual Studio 2003 How to reproduce: Consol...
10
by: Brian Parker | last post by:
I inherited a C++ DLL that I need to remotely call multiple times asynchronously. What I have developed is: CSharp web application that makes asynchronous calls to a CSharp Web Service. The...
0
by: Johnny | last post by:
I have a PocketPC mobile application that gets its data from the Sql Server database via a web service. The web service returns a dataset that I need to load into the SqlCe database on the mobile...
3
etiainen
by: etiainen | last post by:
Hi everyone! I'm in a bit of a problem here: I have to make a maven project for native (jni & C) code. I am using this plugin:...
0
by: jankhana | last post by:
Hi all, I'm using Xenocode in my application so that it works without a .NET framework. I'm using Xenocode Virtual Application Studio(version 6.1). Everything works fine except the .sdf...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.