Forum Discussion
Simon_Billinghurst
Jun 29, 2023Copper Contributor
Database Experimentation Assistant Issue deploying DACPAC when creating Analysis Reports
I have been trying to set up this tool to test upgrading our database compatibility from 2008 to 2016. I have managed to Capture and Replay traces, but when I am trying to create a new Report I am g...
Simon_Billinghurst
Jul 02, 2023Copper Contributor
I executed the sqlpackage.exe command manually and got the same error.
I added /TargetTrustServerCertificate:True to the command and it worked.
I am unsure where to go to from here, I have never dealt with certificates.
The Database Experimentation Assistant does have an option to Trust server certificate, but ticking this does not seem to help, it does not seem to add the /TargetTrustServerCertificate or /SourceTrustServerCertificate parameters to the command when deploying the dacpac.
Simon_Billinghurst
Jul 02, 2023Copper Contributor
Found a workaround, I modified the DEA.exe.config file and added /TargetTrustServerCertificate:True to the SQLPackageExePath
- Sally615Nov 16, 2023Copper Contributor
I'm also having the same problem.
But your solution can't fix it.SqlPackage.exe not found from the path.
I would like to know how you added the option to DEA.exe.config.
- Simon_BillinghurstNov 16, 2023Copper Contributor
I have pretty much given up on DEA, one issue after another, have a call in with Microsoft support which is going nowhere.
Colleague of mine suggest using Workload Tools, which I am just starting to test.https://github.com/spaghettidba/WorkloadToolsAs far as the config file goes it is by default in C:\Program Files(x86)\Microsoft Corporation\Database Experimentation Assistant\dea.exe.configIn this config file under configuration\appSettings you will find SqlPackageExePath I think I just added the TargetTrustServerCertificate:true after the exe.https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage?view=sql-server-ver16