The distribution agent failed to create temporary files in SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » The distribution agent failed to create...

The distribution agent failed to create temporary files in SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

raghumvj

Posted Thursday, July 01, 2010 4:16 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 11:27 PM
Points: 71, Visits: 402

Hi,

We are facing an issue in One of our replication(Distributor) Server, Error says :

The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\100\COM' directory. System returned errorcode 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL21100)
Get help: http://help/MSSQL_REPL21100

Related to this problem I have found an Article KB956032 which says give necessary permissions for COM folder,
I have done that but still error exists.

Then found an article in Microsoft connect saying that update to Latest SP as this is fixed.
Then I noticed my distributor is not updated to SP1 hence applied, with Cumulative Package 4, but no luck I still face this problem.

Our Environment:
All our Publisher, distributor and Subscriber are
SQL Server 2008 x64 bit, Windows Server 2003 x64bit.

Note : I have upgraded my distributor Server from SQL 2005 to SQL 2008 while my rest of distributor and publisher are newly Installed SQL 2008 Servers.

Is this a bug or a configuration issue, need some suggestions.

Post #946042

Rajesh-366416

Posted Thursday, March 01, 2012 3:21 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 28, 2013 7:42 AM
Points: 194, Visits: 226

Did you try exclusing 'C:\Program Files\Microsoft SQL Server\100\COM' from anti virus scan.

Post #1260487

« Prev Topic | Next Topic »

Permissions