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

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'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