Hello,
I need to change the default location for my database snapshots for transactional rep, because there is not enough space. I know how to change the location in the publication properties, but I can't work out how to add/select the sql replication agent/group and give it permissions to the new folder (on the destination server). The agent runs under the sql agent account, after giving it read and write I thought that would be it, but it fails when generating the snapshot.
Anyone know how, please? Thank you.
Regards,
D.