摘要:Replication between 2008R2 and 2012
Publisher: SQL 2008R2
Subscriber: SQL 2012
- 兩台Version不同，"訂閱"需從版本高的那台設定才會成功
- Run了幾天出現error說access denied (很怪!)
Error Message:
Replication-Replication Distribution Subsystem: agent XXXX-XXX-XXX-XXXX-1 failed. The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\100\COM' directory. System returned errorcode 5.
Workaround : grant COM 資料夾 Write的權限給SQL agent service account
Reference : https://support.microsoft.com/en-us/kb/956032