SQL transactional replication is setup but hitting an issue when trying to FTP the files over the internet, we have a VPN connection established to an external server.
The process could not retrieve file 'ServerNamePubName/20171113081054/TableName.pre' from the FTP site 'FTPSITENAME'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20033)
- Publication is enabled for Internet
- FTP is set to allow SSL connections
- Can see the external subscription against the pub
As far as I know the firewall rules have been set correctly, I am waiting on this being confirmed 100% by network team.
If my FTP connection string is incorrect I wouldn't expect the process to see the actual filename, but I am a little confused on the correct syntax with the 'Path from the FTP root folder' setting on the publication, various posts say I don't need the root info of the FTP but need to append FTP at the end?
