Dynamics Community Forum Thread Details

RestoreDB error: connection successfully established with the server, error occurred

Hi guys,

I want to restore UAT database to my own DevBox, but I have strange message while doing the import extraction using SqlPackage.

So when I run this command :

SqlPackage.exe /a:Import /sf:C://Temp//MYuatbackup.bacpac /tsn:FODEV /tdn:AxDB_UAT /p:CommandTimeout=1200

I'm hit this error :

Importing to database 'AxDB_UAT' on server 'FODEV'.
Creating deployment plan
Initializing deployment
*** Changes to connection setting default values were incorporated in a recent release. More information is available at https://aka.ms/dacfx-connection
*** Error importing database:Could not import package.
Unable to connect to target server 'FODEV'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server.
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.

May I know what's wrong and how to resolve it ?

I'm trying to google it, and found this Microsoft docs -> https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/error-message-when-you-connect But to be honest I'm confuse what to do. Because when it is said I need to Export Certificate from Personal, I didn't find the menu All task > Export. Also it is talking about obtain certificate from the server, what server does it mean because this is my DevBox which the server also in this VM.

But there is a note there :

Note

If you are using SQL Server Management Studio, select the Options tab, and select the Trust Server certificate option in the Connection Properties tab.

I tried to open my SSMS, but could not find the Connection Properties, could be different version, so I would like where exactly.