we got the following error
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
by looking at http://support.microsoft.com/default.aspx/kb/956032, which suggest the issue is related to "Distribution Profile for OLEDB streaming" profile, but in our case, we use default profile for distribution agent.
after we reinitailized subscription, the issue was solved, but it came back after a while.
any input will be appreciated
our environment: windows server 2008 enterprise sp1 sql server 2008 64bit enterpise sp1
View Complete Post