Replication between 2008R2 and 2012

摘要: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 :