A call to SQL Server Reconciler failed. Try to resynchronize.
来源:互联网 发布:夏贝贝云盘全套源码 编辑:程序博客网 时间:2024/05/16 06:48
在进行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.
- illustrates how to call a SQL Server stored procedure
- Call to lnusertemp failed
- Failed to contact Jack server Try 'jack-diagnose'
- Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005
- uploadify3.2.1 Call to StartUpload failed Call to ReturnUploadStart failed
- java.lang.IllegalStateException:Unable to initialise endpoint. A previous call to init() failed. See
- java.lang.IllegalStateException:Unable to initialise endpoint. A previous call to init() failed. See
- Error message when you try to save a table in SQL Server 2008: "Saving changes is not permitted"
- How to recover a SQL Server Database
- How to drop a SQL Server database?
- sql express 2008 - Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instan
- Unable to connect to a repository at URL '': authorization failed: Could not authenticate to server:
- Using DBI to connect to a Microsoft SQL server
- The server failed to respond with a valid HTTP response
- Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection
- call to RegDBQueryKey failed的问题
- Error EDDDAV: Call to ZHEGV failed
- Google Gadgets (3):用户设置
- 判断某数是否为质数 [已写成函数]
- ASP.NET上传大文件
- 使用MyEclipse开发Hibernate程序时连不上数据库问题
- Linux Commands Line - v1.1 last changes 06 Jan 2008 06.54 pm
- A call to SQL Server Reconciler failed. Try to resynchronize.
- 学习Ext第一天(Ext 简介)
- java多态
- 从技术到市场驱动 洋教头五年时间改造华为
- 提高String和StringBuffer性能的技巧
- 程序员高手是怎样练成的?
- 编程读取windows98/2000/xp/2003的登录密码
- 打破ISP限制 实现企业内VoIP通讯
- java tips