Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The distribution agent failed to create temporary files in SQL Server 2008 Expand / Collapse
Author
Message
Posted Thursday, July 1, 2010 4:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 20, 2013 9:43 PM
Points: 71, Visits: 405
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
Posted Thursday, March 1, 2012 3:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:27 PM
Points: 194, Visits: 247
Did you try exclusing 'C:\Program Files\Microsoft SQL Server\100\COM' from anti virus scan.
Post #1260487
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse