SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent

Posted on by Andy LeonardCategories:SSIS, SSMS

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.

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>

One thought on “SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent”

  1. Pingback: Dew Drop – July 10, 2024 (#4224) – Morning Dew by Alvin Ashcraft

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.