Forum Discussion

Simon_Billinghurst's avatar
Simon_Billinghurst
Copper Contributor
Jun 30, 2023

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...
sql server
sql server r services
Simon_Billinghurst's avatar
Simon_Billinghurst
Copper Contributor
Jul 03, 2023
Found a workaround, I modified the DEA.exe.config file and added /TargetTrustServerCertificate:True to the SQLPackageExePath
Sally615's avatar
Sally615
Copper Contributor
Nov 17, 2023

Simon_Billinghurst 

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_Billinghurst's avatar
    Simon_Billinghurst
    Copper Contributor
    Nov 17, 2023

    Sally615 

     

    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/WorkloadTools
     
    As far as the config file goes it is by default in C:\Program Files(x86)\Microsoft Corporation\Database Experimentation Assistant\dea.exe.config
     
    In 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
     

Resources