在进行sql server 2005 和 sql server compact 的数据同步复制时总是报错,错误的大体信息如下:
A call to SQL Server Reconciler failed. Try to resynchronize.
详细错误信息:
Error messages:
The schema script 'C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/ReplData/unc/CHN_ADVENTUREWORKSMOBILESTAGING_CUSTOMERLISTPUBLICATION/20080104153204/Customer_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147024891)
Get help: http://help/MSSQL_REPL-2147024891
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
在网上找了很多资料,未解,不过根据各种回帖,颇受启发,应该是权限问题,当IIS_×××访问某个本地目录时权限不足造成的。于是选择一个数据发布,查看其属性,
选择Snapshot标签页,发现它的本地快照目录为“C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/ReplData”,为该目录添加IIS_×××,并赋其完全控制权限,
再次进行同步复制,成功^v^!!
有时间再写一篇完整的创建数据发布与订阅的过程,希望不会拖太久。
A call to SQL Server Reconciler failed. Try to resynchronize.
最新推荐文章于 2023-02-11 16:39:53 发布