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 |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2007-02-06 : 05:38:26
|
| I've created a little test app on my pda .net 20 (windows mobile 5). I the click event of the sync button I create a sql server ce file. In Sql server 2005 I've set up a local publication following a hands on guide. The snapshot is generated. When it tries to replicate it gives me the error: Error 29045 Initializing SQL Server Reconcilier has failed. I've been looking on the web for clues and this error seems to arise from different problems. But I've gone through this checklist:Checked the ntfs permission on the repldata share. Changed the sql server agent from local user to domain administrator account. The snapshot is created. What else could be the problem? Ok this is the error from the snapshot agent monitor:Command attempted:{call sp_MSchecksnapshotstatus (N'ProcDb')}Error messages:Publication 'ProcDb' does not exist. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201022)Get help: http://help/MSSQL_REPL-2147201022Either the publication 'ProcDb' does not exist or you do not have sufficient permissions to access it. Ensure that the publication exists and that the account under which the Merge Agent connects to the Publisher is included in the publication access list (PAL). (Source: MSSQLServer, Error number: 21423)Get help: http://help/21423The publication exists. As I wrote earlier it generates a snapshot. And yes the Merge Agent is included in the publication access list. |
|
|
|
|
|
Error #29045 when merging