Blog Post

Azure SQL Blog
3 MIN READ

Connection Security Improvements in SqlPackage 161

DrewSkwiersKoballa's avatar
DrewSkwiersKoballa
Icon for Microsoft rankMicrosoft
Nov 09, 2022
In version 161 of SqlPackage and DacFx some default connection settings have changed to improve the default security of database connections. In this article we will focus on these changes and what m...
Updated Nov 18, 2022
Version 2.0
azure sql
sql server
Mark_Anderson-'s avatar
Mark_Anderson-
Copper Contributor
Feb 21, 2023

Hi,

I am getting below error while Exporting Database using last 161.8089.0 SqlPackage and the script used to export the database is added below.

Script:
SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB_Test /tf:D:\Test\Test.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false

Error:
C:\Temp\sqlpackage-win7-x64-en-161.8089.0>SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB_Test /tf:D:\Test\Test.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false
Connecting to database 'AxDB_Test' on server 'localhost'.
*** Changes to connection setting default values were incorporated in a recent release. More information is available at https://aka.ms/dacfx-connection
*** Error exporting database:Could not connect to database server.
Changes to connection setting default values were incorporated in a recent release. More information is available at https://aka.ms/dacfx-connection
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.
*** The settings for connection encryption or server certificate trust may lead to connection failure if the server is not properly configured.
Time elapsed 0:00:41.72

 

can someone suggest the solution for this problem?