We are currently in the process of migrating our environments. We have multiple publication servers, a central distributor, and multiple subscribers. We are migrating all parts of the environments.
The first step happened a couple of weeks ago, we migrated a publishing server to a new host and changed the distributor, replication was dropped and recreated without any problems.
The second step is just to change the distributor of another server, this consists of 4 transactional publications. Three went in with any problems the final one was created without issues, the snapshot generated, but the subscription failed with the following error:
The distribution agent failed to create temporary files in blah\blah\COM
I have given the distribution agent account access to the directory on the subscriber but it still fails as we have other servers working this way I do not understand why this is failing.
It think that this may be down to the qreader agent, we didn't use one of these for the first server, which I believe is used for transactional replication with updateable subscriptions which we are not using.
My next step, as this is now affecting production reporting, is to strip out the replication and start from scratch but this time without the qreader agent.
Any comments or recommendations would be appreciated.