I get this error when I try to run the sync on a subscription. I found that this actually has something to do with permissions.
“ String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed”
If the account I am using is a server sysadmin does it still have to be part of the db_owner in publication and distribution dbs as shown below? It has write access to the file share
as well so I am not sure I understand what the problem is? It is also a sysadmin on the client where the subscription is going?