29006-A call to SQL Server Reconciler failed.-The Process could not deliver the snapshot to the Subscriber
- From: pikctsach@xxxxxxxxx
- Date: 5 Jul 2005 20:55:37 -0700
Dear all,
I have tried to use Merge Replication to sync between PDA and SQL
server 2000.
One remarkable thing here is the computer running IIS is different
from computer running SQL Server
--------------------------------------------------------------------------
repl.InternetUrl = "http://" & "computerrunningIIS" & "/"
&"virtualname" & "/sscesa20.dll"
repl.InternetLogin = "Administrator" 'Acount on computer
running IIS
repl.InternetPassword = "Administratorpass" 'pass of
computerrunningIIS
repl.Publisher = "THOANTM"
repl.PublisherDatabase = "MOBILE"
repl.PublisherLogin = "ssv"
repl.PublisherPassword = "ssv"
repl.Publication = "MOBILE_CE"
repl.Subscriber = "THOANTM" 'Same with Publisher
repl.SubscriberConnectionString = CON_STR
--------------------------------------------------------------------------
I have shared snapshot folder on machine running SQL Server
\\thoantm\ReplData and gave Everyone Full control.
On the computerrunningIIS I have configed for SQL server Agent like
following
+http authentication: Basic authentication. Domain
'ComputerrunningIIS'
+NTFS permission:
* NTFS permission : User: computerrunningIIS\Administrator
* NTFS permission : Snaphot Folder: \\thoantm\ReplData
Do the sync..
And I met the error above:
29006 - A call to SQL server Reconciler has failed
....
The process could not deliver snapshot to the subscriber.
I WONT MET THE DESCRIBED PROBLEM IF COMPUTER RUNNING IIS IS ALSO
COMPUTER RUNNING SQL SERVER (2 IN 1)
PLS HELP ME OUT....
.
- Follow-Ups:
- Prev by Date: Re: mixing merge replication with RDA
- Next by Date: Re: database corruption problem
- Previous by thread: Blocking sql statement?
- Next by thread: Re: 29006-A call to SQL Server Reconciler failed.-The Process could not deliver the snapshot to the Subscriber
- Index(es):
Relevant Pages
|
Loading