Home Forums SQL Server 2014 Administration - SQL Server 2014 The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\120\COM' directory. System returned errorcode 5. RE: The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\120\COM' directory. System returned errorcode 5.

  • December 9, 2014 at 4:56 am

    #1763475

    Error Code 5 Signifies Access denied. Account which is being used to run SQL Server Agent does not have write permission on the COM folder.

    Add Write permission on the COM folder for the Agent Account and check again.

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)