473,837 Members | 1,993 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Rod
I orginally posted this to microsoft.publi c.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=Microsof t SQL Server 2000 Windows CE Edition,
NativeError=290 06,HResult=-2147467259

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

Here is difference in my code between Windows and SQL Authentication:
#if SQLAUTHENTICATI ON
repl.PublisherL ogin = "MyLogin"; // publisher Login;
repl.PublisherP assword = "MyPassword "; // publisher Password;
repl.PublisherS ecurityMode =
System.Data.Sql ServerCe.Securi tyType.DBAuthen tication;
#else
repl.PublisherS ecurityMode =
System.Data.Sql ServerCe.Securi tyType.NTAuthen tication;
#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 3491

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

Similar topics

0
4828
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 anonymous subscriptions and the merge publication works successfully for anonymous pull subscriptions also. Now i am trying to setup the same scenario to setup replication over the Internet using FTP. I have created a FTP site and given certain...
0
2276
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 night to database 'Reportdb' on the same machine. The snapshot agent is scheduled to run every night at 10pm on all weekdays except sunday.
0
5774
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 'Subscriber'. Then I created another subscription, but this time, a PUSH, and this time I got the error "The process could not connect to Subsciber". I tried creating a second PULL Subscription, but the error I got was:
2
1501
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 scripts that were previosly created when the database was not this big. I want to copy the publisher DB over to the Subscriber Server. Can I use the parameter @sync_type to 'none' when running the sp_addsubscription? Does anyone have any experience...
2
2867
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 Win32 exe project
10
2642
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 Web Service calls the DLL, which does some heavy processing, then sends the results back to the CSharp web application. The problem is that the calls to the DLL in the Web Service are blocking each other. If I send 10 async requests to the Web...
0
3892
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 device. I have a method to perform this task but it doesn't load the data into the SqlCe database. The data is downloaded into the dataset from the web service just fine but I can't get the data into the SqlCe database. Any suggestions would be...
3
5407
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: http://mojo.codehaus.org/maven-native/native-maven-plugin/index.html and trying to make this example build: http://mojo.codehaus.org/maven-native/native-maven-plugin/examples/jni-dll.html (the jni one in svn)
0
1385
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 file which I have embedded inside the application directory. actually in the application the instead of SQL server i have used SQL Compact edition(3.5) and i have included the reqired dll . All the files are working except the ".sdf" file. Any idea...
0
9846
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9686
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10890
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10634
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10279
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9416
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7007
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5675
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4053
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.