29006-A call to SQL Server Reconciler failed.-The Process could not deliver the snapshot to the Subscriber



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....
.



Relevant Pages

  • RE: Real Simple Question
    ... "JimD" wrote: ... > Hi Folks! ... > I am trying to use 1 computer running XP home networked to a machine using ... > XP Proand SQL Server on 1 other computer. ...
    (microsoft.public.sqlserver.connect)
  • Re: MBSA reports conflicts/Need help to fix them, thanks
    ... have SQL server running on your XP computer. ... "SQL Server Authentication ModeCheck Description ... This check determines the authentication mode used on the computer running ... SQL Server provides two modes for securing access to the server: Windows ...
    (microsoft.public.windowsxp.security_admin)
  • Re: 29006-A call to SQL Server Reconciler failed.-The Process coul
    ... You can access SQL Server CE Knowledge Base articles at: ... > while, the regular user can no longer sync, they get the "... ... >> Server Mobile server tools package and then re-install Server tool on IIS ... >>> One remarkable thing here is the computer running IIS is different ...
    (microsoft.public.sqlserver.ce)
  • Re: Problem about install SMS2003(error:sql is down)
    ... > I noticed from the log that when you were prompted for the 'Computer running ... > SQL Server', you entered 'ERIC2005\SMS'. ... sql named instanced which isn't support by sms. ... Prev by Date: ...
    (microsoft.public.sms.setup)
  • Background Intelligent Transfer Service
    ... I am running IIS on Windows 2003 with Ad, SQL SERVER and ... SMS the server is a domain controller. ... the error message in the event log The Background ...
    (microsoft.public.windows.server.general)

Loading