Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2004-04-18 : 10:57:09
|
| Hello...Still more problems with Replication since we changed from Windows 2000 server to Windows 2003.Merge Replication was working fine on our Windows 2000 server. Since we changed to Windows 2003, we only get the error about the "Reconciler has failed [,,,,,]" error message. I completely removed the previous Replication setup in SQL Server and started from the beginning again. I am NOT publishing to the default location, rather to a Share. I have made sure to set the Sharing and Security permissions (both tabs on the folder's property sheet) to allow the IIS User and the Sql Agent account Full Control. I added both the IIS user and Sql Agent accounts to the Publications PAL.I made sure to register the SQL CE DLLs at the share location.If I browse to http://Myserver.com/SQLCE_Share/sscesa20.dll I receive the message "SQL Server CE Server Agent" which, from the docs, tells me that the sql ce agent is configured properly.Basically, I have done everything exactly as I had before with Windows 2000 and it worked...but with Windows 2003 it is not working. Further, my attempts to get the sqlCe logging to be more verbose do not work. I reset the value in the registry....restarted IIS several times (even re-boot the server) and all I get are single lines that state "2004/04/17 18:21:10 Hr=00000000 SSCESA20.DLL loaded 0", which indicates that the Sql CE Agent loaded successfully.If anyone has any thoughts or suggestions, that would be great. Thanks - dw |
|
|
|
|
|
|
|
Replication - Reconciler Failed.....