Downgrade the version of SqlServer in Windows 2022 and 2025 #13578
Description
Description
When we are using AzureSqlDatabaseDeploymentV0 task it is getting failed with authentication type as AAD with password.
It is only failing with Windows 2022 and 2025 and these versions of agents are consuming 22.4.5.1 version of SQL which is broken.
Platforms affected
- Azure DevOps
- GitHub Actions - Standard Runners
- GitHub Actions - Larger Runners
Runner images affected
- Ubuntu 22.04
- Ubuntu 24.04
- Ubuntu Slim
- macOS 14
- macOS 14 Arm64
- macOS 15
- macOS 15 Arm64
- macOS 26 Arm64
- Windows Server 2022
- Windows Server 2025
Image version and build link
Windows 2022 and 2025
Is it regression?
Yes
Expected behavior
AzureSqlDatabaseDeploymentV0 task should succeed without any issues.
Actual behavior
AzureSqlDatabaseDeploymentV0 task is failing with error
[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-
Repro steps
steps:
- task: SqlAzureDacpacDeployment@1
displayName: 'Azure SQL InlineSqlTask'
inputs:
azureSubscription: NewSCAbhiWIF
AuthenticationType: aadAuthenticationPassword
ServerName: azuretestabhi.database.windows.net
DatabaseName: xyz
aadSqlUsername: abcd
aadSqlPassword: '$(secret)'
deployType: InlineSqlTask
SqlInline: |
PRINT 'abc'