Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Error

Author  Topic 

ranganath
Posting Yak Master

209 Posts

Posted - 2009-10-23 : 06:28:22

Hi,
iam using sql2008. the Following error getting while executing the Replication

The distribution agent failed to create temporary files in C:\Program Files\Microsoft SQL Server\100\COM directory. System returned errorcode 5.

please advice

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-10-23 : 06:58:06
I would say that yopur SQL Agent account (or the account you are using for your replication) does not have write access to that directory. Give it write access in Windows security and it will start working.
Go to Top of Page
   

- Advertisement -