Azure devops - SSIS Deploy

0
votes

Following is the error am getting when using "SSIS Deploy" plugin in my Release Job.

Azure Devops Release - Deploy SSIS (Tried using SQL Authentication failed & using ActiveDirectory Password, it is connecting but it is failing to establish the connection with the SSISDB database). When i connect using Windows Authentication enter image description here

Error: Funny thing is i can connect SSISDB from my SSMS without issues using my sa account. However using Azure Devops - SSIS Deploy plugin I cannot deploy the SSIS packages using sa account. Crazy! enter image description here

1
deploymentssisazure-devops
Not get your latest information, is the answer helpful for you? Or if you have any concern, feel free to share it here. - Hugh Lin

1 Answers

1
votes

Whether a specific authentication type is supported depends on destination server type and agent type. Detail support matrix is listed in below table. Please refer to this document .

enter image description here

In addition, here is a case with similar issue you can refer to.