Azure DevOps Server (onPrem) SQL DB Deploy - how to add certificate trust?
I am using TFS (Azure DevOps Server 2019) and am trying to use the SQL DB Deploy (version 0.*) step to perform a publish of a SQL script.
I am getting the error: The connection was successful -- The certificate chain was issued by an authority that is not trusted
I believe the solution is to add TrustServerCertificate=True to the connection string.
Does anyone know how to add this in the DevOps step?
Regards
I have been facing the same error lately. After multiple attempts and trying several combinations, I was able to figure out a way by which we can pass an additional argument in the SQL Server Database Deploy task in DevOps Release pipeline to have the encrypt connection property set to false same as below:
-EncryptConnection:0
Attaching a screenshot of the pipeline too below:
- run azuredevops task in all agents of the specified pool
- How to debug extension in Azure DevOps Server
- Get List of Collection REST API - Azure DevOps Server (TFS)
- Azure DevOps Server pipeline build fails when using self-signed SSL certificate with "unable to get local issuer certificate" during NuGet restore
- how to list and find all the secrets in the keyvault which is to be expired in next 60 days?
- How to change the agent build directory?
- How do I disable HTTPS redirect in Azure DevOps Server 2019 upd 1.1?
- How do I troubleshoot extensions in Azure DevOps Server that times out?
- What Azure DevOps Server / Team Foundation Server version first introduced support for Git LFS
- Storing 3rd-party DLLs in source control (Azure DevOps/TFS/Git)
- How to clone a stage but have a link to artifact in azure dev ops 2019
- What are the available parameters/inputs for configuring unattended setup for TFS?
- Azure DevOps Server (onPrem) SQL DB Deploy - how to add certificate trust?
- what is the way to get the variable group id of AzureDevops using CLI command
- How do you get a list of all project iterations using the Azure DevOps Services .NET SDK?
- How to create rules for work items in TFS 2018 and TFS 2019?
- Pull request policies - Build expires after another pull request was completed. Way to automatically rerun expired builds for other PRs?
- How to use a test plan (it is a manual test) on Azure devops 2019 CI/CD pipeline
- Unable to install Test Manager extension on Azure DevOps Server 2019
- How to merge the changes of a Work Item to branches other than the source branch?
- tfs 2019 Pipeline Builds Triggers only trigger if a new check-in has happened
- Move product backlog items to another teamwork board project
- Upgrade TFS2017.3 to Azure DevOps Server
- Automatically promote a nuget packge using a relese definition
- Add AAD user account via group to Azure DevOps
- How to use Azure DevOps Extension for Azure CLI with Azure DevOps Server?
- Azure DevOps - Multiple projects with multiple Kanban boards vs Single Project with multiple repositories
- How to uninstall or remove configuration of a deployment pool or deployment agent
- Can't move between independent area paths Azure DevOps
- How can I retrieve a list of Azure DevOps Wiki pages to be able to edit them?