I’m reading Announcing SSMS 20.2 … and getting feedback for SSMS 21 by Erin Stellato (LinkedIn) on the SQL Server Blog and this fix caught my eye:
SSIS and SQL Agent – many customers ran into a connection error (“The certificate chain was issued by an authority that is not trusted”) in SQL Agent when trying to create or modify a job step for SQL Server Integration Services (SSIS).
I had not personally encountered this one. Reading the issue link, it appears to have shown up three-ish months ago. Kudos to the SSMS team for addressing it and for addressing it quickly.
One thought on “SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent”