The distribution agent failed to create temporary files in xxx directory. System returned errorcode 5 散發代理程式建立暫存檔失敗

  • Article

The distribution agent failed to create temporary files in ... directory. System returned errorcode 5

散發代理程式建立暫存檔失敗

Error: 錯誤訊息

當你修改了散發代理程式的處理帳號(執行帳號)

When you change the Agent process account in the Distribution Agent Security 

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

Cause: 原因

新的執行帳號，對C:\Program Files\Microsoft SQL Server\110\COM 目錄沒有權限

Resolution: 解決方法

設定新的執行帳號對 C:\Program Files\Microsoft SQL Server\110\COM 目錄有寫入的權限

Reference: 參考

Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"
https://support.microsoft.com/en-us/help/956032/error-message-when-you-run-the-distribution-agent-in-sql-server-2008-o