SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Native Error 29006, The process could not deliver the snapshot to the Subscriber


Native Error 29006, The process could not deliver the snapshot to the Subscriber

Author
Message
Rod Early
Rod Early
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 52
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.DBAuthentication;
#else
repl.PublisherSecurityMode =
System.Data.SqlServerCe.SecurityType.NTAuthentication;
#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?

Thanks,
Rod Early


Site Owners
Site Owners
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: Administrators
Points: 12597 Visits: 16
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Connie Poon
Connie Poon
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 1

Not sure if it could help.

Accord to SQLCE BOL - tried to verify that the user get read permission for the table...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_troubleshooting_security_problems.asp


jonny.barnstorf
jonny.barnstorf
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 113
I had the same problem:
The snapshot location was incorrectly set in the replication properties

the Replication wizard defaults the snapshot directory to something like:
\\ServerName\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData

If you have specified a different directory you will need to set the properties to something like:
\\ServerName\SnapShotDirectory

in Enterprise Manager (EM) you would find this under
-Tools -Replication -Configure Publishing...
select the [Publishers Tab]
select the [...] elipsis of the distrubtion db and set the snapshot folder in there.

That's what worked for me :-)
Rajesh Patil
Rajesh Patil
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 21
The Problem is not with the code its with the security settings of the reconciler dll location that you have on the desktop computer. try to check those setttings that might solve your problem. sorry to respond late and vague. Its been long time I tried out replication on handheld devices.
Regards,
Rajesh.
MBA-IT (Software Dev & Mgmt)
SCIT- 2007-09
rchavez
rchavez
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 13
Hi, if you solve the probem please tell me how I have the same problem.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search