Merge Replication

  • Thread starter Thread starter cristina
  • Start date Start date
C

cristina

Hi!
I can´t merge Replication on my PocketPC. (MS SQL Server
2000 - MS SQLCE 2.0 Server)

When I try to synchronize(), I obtain the next error:
Initializing SQL Server Reconciler has failed.[,,,,]
HRESULT:-2147198719


I have changed several times the IIS configuration
settings, publication properties, permissions, etc but I
stay allways in the same point. Could you please tell me
what you changed in the publication´s properties or if
you see something wrong in mine? My publication´settings
are:
-Snapshot:Character mode format
-Snapshot Location: \\MHPA22AC\E$\SqlRepl (shared)
-PubAccess List: IUSR_MHPA22ac included
-Sync Partners: Allow subscribers to synchronize...
-Status: Last run:01.10.2003 09:23:55 SQLServerAgent
running
-Subscription options: everything selected
-Subscriptions: empty (I want to make subscriptions
programmatically)


I use anonymous Access, i have set the permissions for
IUSR_MHPA22AC in the replication folder and virtual
folder. My account is administrator.
I have already registered the sscesa20.dll and verified
that i have configured it correctly.

I do something wrong, but i dont know what else i could
try.

Thanks for help!!
Cristina
 
Try to disable all publications and ricreates them all,
then try to replicate. This should resolve your problem.

Antares.
 
Thanks,
i have tried what you said, but no success. Do you have
any other idea?
(almost 3 days with the same problem...grrr)
Cristina
-----Original Message-----
Try to disable all publications and ricreates them all,
then try to replicate. This should resolve your problem.

Antares.

-----Original Message-----
Hi!
I can´t merge Replication on my PocketPC. (MS SQL Server
2000 - MS SQLCE 2.0 Server)

When I try to synchronize(), I obtain the next error:
Initializing SQL Server Reconciler has failed.[,,,,]
HRESULT:-2147198719


I have changed several times the IIS configuration
settings, publication properties, permissions, etc but I
stay allways in the same point. Could you please tell me
what you changed in the publication´s properties or if
you see something wrong in mine? My publication´settings
are:
-Snapshot:Character mode format
-Snapshot Location: \\MHPA22AC\E$\SqlRepl (shared)
-PubAccess List: IUSR_MHPA22ac included
-Sync Partners: Allow subscribers to synchronize...
-Status: Last run:01.10.2003 09:23:55 SQLServerAgent
running
-Subscription options: everything selected
-Subscriptions: empty (I want to make subscriptions
programmatically)


I use anonymous Access, i have set the permissions for
IUSR_MHPA22AC in the replication folder and virtual
folder. My account is administrator.
I have already registered the sscesa20.dll and verified
that i have configured it correctly.

I do something wrong, but i dont know what else i could
try.

Thanks for help!!
Cristina

.
Click to expand...
.
Click to expand...
 
Cristina,

there is a lot that can be done wrong with replication. It seems to me
that you already know the main things but nonetheless, if you don't know
it there are good documentations at
http://www.microsoft.com/sql/ce/techinfo/default.asp. And generally
these things should be discussed at microsoft.public.sqlserver.ce. There
are very good and hard working guys from MS.
Regards,
Christoph
Thanks,
i have tried what you said, but no success. Do you have
any other idea?
(almost 3 days with the same problem...grrr)
Cristina

-----Original Message-----
Try to disable all publications and ricreates them all,
then try to replicate. This should resolve your problem.

Antares.


-----Original Message-----
Hi!
I can´t merge Replication on my PocketPC. (MS SQL
Click to expand...
Server
2000 - MS SQLCE 2.0 Server)

When I try to synchronize(), I obtain the next error:
Initializing SQL Server Reconciler has failed.[,,,,]
HRESULT:-2147198719


I have changed several times the IIS configuration
settings, publication properties, permissions, etc but
Click to expand...
I
stay allways in the same point. Could you please tell
Click to expand...
me
what you changed in the publication´s properties or if
you see something wrong in mine? My
Click to expand...
publication´settings
are:
-Snapshot:Character mode format
-Snapshot Location: \\MHPA22AC\E$\SqlRepl (shared)
-PubAccess List: IUSR_MHPA22ac included
-Sync Partners: Allow subscribers to synchronize...
-Status: Last run:01.10.2003 09:23:55 SQLServerAgent
running
-Subscription options: everything selected
-Subscriptions: empty (I want to make subscriptions
programmatically)


I use anonymous Access, i have set the permissions for
IUSR_MHPA22AC in the replication folder and virtual
folder. My account is administrator.
I have already registered the sscesa20.dll and verified
that i have configured it correctly.

I do something wrong, but i dont know what else i could
try.

Thanks for help!!
Cristina

.

.
Click to expand...
Click to expand...
Click to expand...
 
Hi,

I also got this error twice. These were my solutions, maybe it will help:
Check your publisher name. Try using IP address instead of DNS name.
Try re-runing the snapshot agent (in case you have modified the
publication).

Simone
 
Hi Christina,

Make sure that your IIS Server has the sscerp20.dll registered.

If your IIS and SQL Server are seperate, then make sure that the IIS User
can access the snapshot folder.

For you publication, change the snapshot folder to a UNC path, something
like \\server_name\snapshot. The default is \\Servername\c$\program
files\.... Your IIS user needs to have permissions to access the c$, which
you may not want to grant.

Read the white papers on configuration at http://www.microsoft.com/sql/ce.
There is a link there.

--
Brad
(e-mail address removed)
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi!
I can´t merge Replication on my PocketPC. (MS SQL Server
2000 - MS SQLCE 2.0 Server)

When I try to synchronize(), I obtain the next error:
Initializing SQL Server Reconciler has failed.[,,,,]
HRESULT:-2147198719


I have changed several times the IIS configuration
settings, publication properties, permissions, etc but I
stay allways in the same point. Could you please tell me
what you changed in the publication´s properties or if
you see something wrong in mine? My publication´settings
are:
-Snapshot:Character mode format
-Snapshot Location: \\MHPA22AC\E$\SqlRepl (shared)
-PubAccess List: IUSR_MHPA22ac included
-Sync Partners: Allow subscribers to synchronize...
-Status: Last run:01.10.2003 09:23:55 SQLServerAgent
running
-Subscription options: everything selected
-Subscriptions: empty (I want to make subscriptions
programmatically)


I use anonymous Access, i have set the permissions for
IUSR_MHPA22AC in the replication folder and virtual
folder. My account is administrator.
I have already registered the sscesa20.dll and verified
that i have configured it correctly.

I do something wrong, but i dont know what else i could
try.

Thanks for help!!
Cristina
 
Hi,
I had the same problem, and tried all sugestions, none of
them worked. At last I tried to add the user I use for my
sql ce appliction to the user for the db I would like to
replicate, then I added him to the publication access
list, and that worked.

/Kenneth :-)
-----Original Message-----
Thanks,
i have tried what you said, but no success. Do you have
any other idea?
(almost 3 days with the same problem...grrr)
Cristina
-----Original Message-----
Try to disable all publications and ricreates them all,
then try to replicate. This should resolve your problem.

Antares.

-----Original Message-----
Hi!
I can´t merge Replication on my PocketPC. (MS SQL Server
2000 - MS SQLCE 2.0 Server)

When I try to synchronize(), I obtain the next error:
Initializing SQL Server Reconciler has failed.[,,,,]
HRESULT:-2147198719


I have changed several times the IIS configuration
settings, publication properties, permissions, etc but I
stay allways in the same point. Could you please tell me
what you changed in the publication´s properties or if
you see something wrong in mine? My publication´settings
are:
-Snapshot:Character mode format
-Snapshot Location: \\MHPA22AC\E$\SqlRepl (shared)
-PubAccess List: IUSR_MHPA22ac included
-Sync Partners: Allow subscribers to synchronize...
-Status: Last run:01.10.2003 09:23:55 SQLServerAgent
running
-Subscription options: everything selected
-Subscriptions: empty (I want to make subscriptions
programmatically)


I use anonymous Access, i have set the permissions for
IUSR_MHPA22AC in the replication folder and virtual
folder. My account is administrator.
I have already registered the sscesa20.dll and verified
that i have configured it correctly.

I do something wrong, but i dont know what else i could
try.

Thanks for help!!
Cristina

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top