SSMS 20.1 Unable to see SSIS Execution Properties

Question

Ever since I installed SSMS 20.1, I've been unable to look up the properties in SSIS jobs.

I'm aware that 20.1 has changed the way connections are made but my connection is set up with "Trust server certificate" and multiple menus error out.

I've also added Encrypt=False; in the additional connection parameters.

See attached image.

So far, the only workaround would be to install SSMS 19 but I'd rather be able to connect using the latest version.

Answer 1

This is a known issue, see https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16.

Answer 2

Hi @Michel Lalancette，

As said in the official documentation, the workaround is using SSMS 19.3 temporarily.

Or you may wait for the new release which will fix the issue.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.