SqlPackage error while exporting .dacpac
Since the latest release of SqlPackage on February 13, 2023 (build 161.8089.0) I got stuck on this connection issue while trying to extract the data of an Azure DevOps Server Project Collection for migration to Azure DevOps.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 — The certificate chain was issued by an authority that is not trusted.). The certificate chain was issued by an authority that is not trusted.
In the past it has always been a struggle to find the required SqlPackage executable on the machine I used for extracting data but the last couple of months I have always used this release notes page to easily download the latest version of SqlPackage.
The error was quite a surprise and after doing some investigation I wasn’t making any progress until I finally noticed this subtle message on the release notes page.
Apparently the new default encryption setting was causing some unexpected error.
Quick workaround: download a previous version of SqlPackage and all will work as expected! Back on track for another successful migration towards Azure DevOps.
