Error message from my SSIS job: SSL Provider: The target principal name is incorrect

Question

Hi,

I have an SSIS package and what it does is to extract data from a source and then update one of our SQL server DB table.

The SSIS package is deployed on our SSIS server (this is different from the SQL Server DB mentioned above), and an SSIS job is created on SQL Server Agent to schedule and run the job. The job had been running fine until yesterday, when I found that there was an error message in connecting to the destination (SQL server DB): "SSL Provider: The received certificate has expired"

So I contact our DBA and they managed update the SSL certificate on the SQL server. But when I tried to rerun the SSIS job from SSIS server, it still failed and this time it gave a different error message: "SSL Provider: The target principal name is incorrect"

I wonder what target principal name is it referring to? I am not a DBA and has limited knowledge on SQL server. Could someone please point me the right direction? I have done some research online, and it might be a DNS issue or the name has not been updated.

Thanks

Answer 1

SSL certificates are attached to a server. They generated the SSL cert and entered the wrong server name, or copied it from another server. Contact your DBA again.