• 20-July-2013

    Taken out replication overnight, disabled qreader job on distributer.

    Recreated all four publications - no problems all snapshots created.

    Three subscriptions work fine.

    The last one again fails because of the following error:

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

    This is not an updateable subscription, the snapshot is over 35GB which shouldn't be an issue. I believe that the c: drive referred to is that on the subscriber - which the distribution agent has full access to.

    Any ideas?