Hi,
I have an SSIS Package which collects some data and then FTP it to a FTPS-server. The FTPS server has a Verisign-certificate that is valid, and I have verified that the Root Certificate is in the SQL-servers "Trusted Root Certification Authorities".
The package is working fine when running in Visual Studio on dev-server but when I try to run it from SQL Server Agent it fails and error message is "The remote certificate is invalid according to the validation procedure."
I have verified the Root Cert on the SQL-server by logging on with admin-account and ran a ftps-cmdline client and then I'm able to connect to the server without any certificate warnings. I'm guessing the SQL Server Agent service accounts perhaps don't have enough permissions to read the root certs and therefore can't validate the SSL Certificate?
Any ideas?