Replication failed only on one database.

• Minto Minto(quendans)

  SSCrazy

  Points: 2533

  More actions

  November 20, 2014 at 3:21 am

  #295247

  Hi ,

  We are using transactional replication between 2012 and 2088 R2 servers.Replication is configured on several databases but it is failing with below error only on one Database.

  Replication-Replication Distribution Subsystem: agent I'job name' failed. The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\110\COM' directory. System returned errorcode 5.

  Login has write permission on this folder.Are there any other reasons?

  Please let me know if there is any solution for this.

  Thanks in advance.

• mxy

  SSCarpal Tunnel

  Points: 4036

  More actions

  May 7, 2015 at 10:38 am

  #1796305

  transactional or snapshot. why you are using C drive?

  use unc path which should a shared directory.

  for your issue check whether directory is shared or not. check in event viewer it may give more information