docker – Connecting to SQL Server from SSMA (the certificate chain was issued by an authority that is not trusted!)


I am trying to use SQL Server Migration Assistant for the first time from my home PC. I have SQL Server in one Docker container and Oracle in another. I can connect to Oracle from SSMA, however when trying to connect to SQL Server I see this error:

enter image description here

I have read plenty of questions on here that explain how to resolve the problem if it is seen when connecting from SQL Studio Manager e.g. this one: The certificate chain was issued by an authority that is not trusted. I have no problem connecting from SQL Studio Manager – just SSMA. How can I connect to SQL server from SSMA?

I have tried unticking ‘Encrypt connection’ on the SSMA SQL Server login window and I see the same error.