Our replication job was getting failed with below error. To resolve this issue I have granted write permission to agent account on COM folder. Now job is running fine.
Error:Agent message code 21100. The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\100\COM' directory
Question is, replication job was running fine till yesterday without having such permission on folder now how suddenly job is getting failed?
Did the replication job performs update on a large object(LOB) column, for example, XML column? If you use the "Distribution Profile for OLEDB streaming" profile for the Distribution Agent, the Distribution Agent creates temporary files in the
following directory:C:\Program Files\Microsoft SQL Server\100\COM. You may receive this error message when the account that is running SQL Server Agent does not have write access to the COM folder.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?