Post reply

The distribution agent failed to create temporary files

  • May 13, 2009 at 10:08 am

    #204786

    Hello room,

    I run into errors of "The distribution agent failed to create temporary files" on my SQL Server 2008 remote distribution.

    There is an article posted by Microsoft to fixed this issue. http://support.microsoft.com/kb/956032

    I already assigned and granted Database Engine, SQL Server Agent, etc to have (Read & Execute) On COM folder but I am still getting those errors. How can I find out the remote distribution agent name in the RDN?

    I'm not clear on the Work-Around steps.

    Please help and advice.

    Thanks

    Ediwn

  • May 13, 2009 at 1:03 pm

    #994006

    In that link:

    ... If the account that is running SQL Server Agent does not have write access to the COM folder ...

    Also the account used by the SQL Agent is what is important!

    Hope it helps.


    * Noel

  • May 13, 2009 at 3:21 pm

    #994138

    I tested out and grant full access to SQL Server Agent.

    Did I need to run the initial snapshot?

  • May 15, 2009 at 11:23 am

    #995538

    Sorry for the delay... been busy. 😉

    I guess you do have to run the snapshot but I am not 100% sure where you are on this.


    * Noel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply