[BUG]: Task fails when using Inline SQL

[PedroC88]

New issue checklist

• I searched for existing GitHub issues
• I read pipeline troubleshooting guide
• I checked how to collect logs

Task name

Azure SQL Database deployment

Task version

1.*

Issue Description

When using Inline SQL the pipeline fails with the following error

Method not found: 'Microsoft.Identity.Client.PublicClientApplicationBuilder Microsoft.Identity.Client.PublicClientApplicationBuilder.WithParentActivityOrWindow(System.Func`1<System.Windows.Forms.IWin32Window>)'.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-

Based on this other issue reported on SqlServerPSModule, it looks like there's an issue with Invoke-SqlCMD version 22.4.5.1 and reverting to 22.3.0 is a valid work around.

Environment type (Please select at least one enviroment where you face this issue)

• Self-Hosted
• Microsoft Hosted
• VMSS Pool
• Container

Azure DevOps Server type

dev.azure.com (formerly visualstudio.com)

Azure DevOps Server Version (if applicable)

No response

Operation system

Windows-Latest

Relevant log output

Method not found: 'Microsoft.Identity.Client.PublicClientApplicationBuilder Microsoft.Identity.Client.PublicClientApplicationBuilder.WithParentActivityOrWindow(System.Func`1<System.Windows.Forms.IWin32Window>)'.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION] 

Repro steps

[PedroC88]

Few additional details

• This issue also happens when using scripts (instead of Inline SQL)
• The issue also happens when using the connection string instead of the Active Directory Password
• Using the default Invoke-SqlCmd on an Azure CLI task, with a connection string with Active Directory Password works fine

[mdc17]

Having same problem when using Inline SQL

[aaronthomps]

Having the same problem running inline SQL using task SqlAzureDacpacDeployment@1. Started 2025-06-20