search

microsoft / azure-pipelines-tasks

Tasks for Azure Pipelines
https://aka.ms/tfbuild
MIT License
3.51k stars 2.62k forks source link

[BUG]: SqlAzureDacpacDeployment fails when Azure SQL Server's minimum TLS version is set to 1.3 #20643

Open Veflow opened 1 week ago

Veflow commented 1 week ago

New issue checklist

Task name

SqlAzureDacpacDeployment

Task version

1

Issue Description

When using this Task to connect to an Azure SQL Server, where the min. TLS version is set to 1.3, I get an error:

##[error]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.

The same Task config works perfectly fine when switching the min. TLS version back to 1.2 on the SQL Server resource in Azure.

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

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

2024-11-11T12:47:11.1801187Z ##[section]Starting: Setup initial SQL permissions
2024-11-11T12:47:11.1809700Z ==============================================================================
2024-11-11T12:47:11.1809870Z Task         : Azure SQL Database deployment
2024-11-11T12:47:11.1809981Z Description  : Deploy an Azure SQL Database using DACPAC or run scripts using SQLCMD
2024-11-11T12:47:11.1810147Z Version      : 1.247.0
2024-11-11T12:47:11.1810235Z Author       : Microsoft Corporation
2024-11-11T12:47:11.1810356Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment
2024-11-11T12:47:11.1810521Z ==============================================================================
2024-11-11T12:47:13.0514453Z Added TLS 1.2 in session.
2024-11-11T12:47:28.3667254Z Temporary inline SQL file: C:\Users\VssAdministrator\AppData\Local\Temp\tmp825F.tmp
2024-11-11T12:47:28.3765184Z Invoke-Sqlcmd -AccessToken "**********" -ServerInstance "***" -Database "***"  -Inputfile "C:\Users\VssAdministrator\AppData\Local\Temp\tmp825F.tmp" 
2024-11-11T12:47:41.4449321Z Temporary inline SQL file: C:\Users\VssAdministrator\AppData\Local\Temp\tmpB586.tmp
2024-11-11T12:47:41.4462916Z Invoke-Sqlcmd -AccessToken "**********" -ServerInstance "***" -Database "***"  -Inputfile "C:\Users\VssAdministrator\AppData\Local\Temp\tmpB586.tmp" -Encrypt Strict
2024-11-11T12:47:41.7422897Z ##[error]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:47:41.8062368Z ##[section]Finishing: Setup initial SQL permissions

Full task logs with system.debug enabled

2024-11-11T12:56:30.7273944Z ##[debug]Evaluating condition for step: 'Setup initial SQL permissions'
2024-11-11T12:56:30.7274986Z ##[debug]Evaluating: SucceededNode()
2024-11-11T12:56:30.7275485Z ##[debug]Evaluating SucceededNode:
2024-11-11T12:56:30.7276234Z ##[debug]=> True
2024-11-11T12:56:30.7276648Z ##[debug]Result: True
2024-11-11T12:56:30.7276988Z ##[section]Starting: Setup initial SQL permissions
2024-11-11T12:56:30.7351787Z ==============================================================================
2024-11-11T12:56:30.7351984Z Task         : Azure SQL Database deployment
2024-11-11T12:56:30.7352085Z Description  : Deploy an Azure SQL Database using DACPAC or run scripts using SQLCMD
2024-11-11T12:56:30.7352234Z Version      : 1.247.0
2024-11-11T12:56:30.7352314Z Author       : Microsoft Corporation
2024-11-11T12:56:30.7352423Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment
2024-11-11T12:56:30.7352586Z ==============================================================================
2024-11-11T12:56:31.8210032Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2024-11-11T12:56:32.1045156Z ##[debug]Entering D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\DeploySqlAzure.ps1.
2024-11-11T12:56:32.1419113Z ##[debug]INPUT_CONNECTEDSERVICENAMESELECTOR: 'ConnectedServiceNameARM'
2024-11-11T12:56:32.1455309Z ##[debug]INPUT_TASKNAMESELECTOR: 'inlineSqlTask'
2024-11-11T12:56:32.1550576Z ##[debug]INPUT_DACPACFILE: 'D:\a\1\s'
2024-11-11T12:56:32.1551951Z ##[debug]INPUT_SQLFILE: 'D:\a\1\s'
2024-11-11T12:56:32.1563161Z ##[debug]INPUT_SQLINLINE: 'IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = 'TRANSLATOR-SQL-WRITERS-DEV-SG')
2024-11-11T12:56:32.1573587Z ##[debug]  BEGIN      
2024-11-11T12:56:32.1588546Z ##[debug]    CREATE USER [TRANSLATOR-SQL-WRITERS-DEV-SG] FROM EXTERNAL PROVIDER
2024-11-11T12:56:32.1617834Z ##[debug]  END
2024-11-11T12:56:32.1648339Z ##[debug]
2024-11-11T12:56:32.1649822Z ##[debug]ALTER ROLE db_datareader ADD MEMBER [TRANSLATOR-SQL-WRITERS-DEV-SG];
2024-11-11T12:56:32.1663749Z ##[debug]ALTER ROLE db_datawriter ADD MEMBER [TRANSLATOR-SQL-WRITERS-DEV-SG];
2024-11-11T12:56:32.1670590Z ##[debug]ALTER ROLE db_ddladmin   ADD MEMBER [TRANSLATOR-SQL-WRITERS-DEV-SG];
2024-11-11T12:56:32.1686396Z ##[debug]GRANT VIEW DEFINITION TO [TRANSLATOR-SQL-WRITERS-DEV-SG];
2024-11-11T12:56:32.1703628Z ##[debug]env:'
2024-11-11T12:56:32.1735622Z ##[debug]INPUT_BACPACFILE: 'D:\a\1\s'
2024-11-11T12:56:32.1767291Z ##[debug]INPUT_SERVERNAME: '***'
2024-11-11T12:56:32.1797254Z ##[debug]INPUT_DATABASENAME: '***'
2024-11-11T12:56:32.1830695Z ##[debug]INPUT_CONNECTEDSERVICENAME (empty)
2024-11-11T12:56:32.1890589Z ##[debug]INPUT_CONNECTEDSERVICENAMEARM: '3163c192-0233-454a-8e86-1daae8f974c0'
2024-11-11T12:56:32.1923554Z ##[debug]INPUT_SQLUSERNAME (empty)
2024-11-11T12:56:32.1950666Z ##[debug]INPUT_SQLPASSWORD (empty)
2024-11-11T12:56:32.1981731Z ##[debug]INPUT_AADSQLUSERNAME (empty)
2024-11-11T12:56:32.2014808Z ##[debug]INPUT_AADSQLPASSWORD (empty)
2024-11-11T12:56:32.2041942Z ##[debug]INPUT_DEPLOYMENTACTION: 'Publish'
2024-11-11T12:56:32.2071717Z ##[debug]INPUT_AUTHENTICATIONTYPE: 'servicePrincipal'
2024-11-11T12:56:32.2100818Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2024-11-11T12:56:32.2135318Z ##[debug]INPUT_PUBLISHPROFILE: 'D:\a\1\s'
2024-11-11T12:56:32.2160781Z ##[debug]INPUT_ADDITIONALARGUMENTS (empty)
2024-11-11T12:56:32.2189651Z ##[debug]INPUT_SQLADDITIONALARGUMENTS (empty)
2024-11-11T12:56:32.2219883Z ##[debug]INPUT_INLINEADDITIONALARGUMENTS: '-Encrypt Strict'
2024-11-11T12:56:32.2852825Z ##[debug]INPUT_IPDETECTIONMETHOD: 'AutoDetect'
2024-11-11T12:56:32.2879850Z ##[debug]INPUT_STARTIPADDRESS (empty)
2024-11-11T12:56:32.2909559Z ##[debug]INPUT_ENDIPADDRESS (empty)
2024-11-11T12:56:32.2968735Z ##[debug]INPUT_DELETEFIREWALLRULE: 'true'
2024-11-11T12:56:32.2999490Z ##[debug] Converted to bool: True
2024-11-11T12:56:32.3063572Z ##[debug]Loading module from path 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureHelpers_\VstsAzureHelpers_.psm1'.
2024-11-11T12:56:32.3172727Z ##[debug]$OVERRIDING $global:DebugPreference from 'Continue' to 'SilentlyContinue'.
2024-11-11T12:56:32.3205066Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureHelpers_/module.json
2024-11-11T12:56:32.3678091Z ##[debug]Loaded 19 strings.
2024-11-11T12:56:32.4544253Z ##[debug]SYSTEM_CULTURE: 'en-US'
2024-11-11T12:56:32.4546330Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureHelpers_\Strings\resources.resjson\en-US\resources.resjson
2024-11-11T12:56:32.4605784Z ##[debug]Loaded 19 strings.
2024-11-11T12:56:32.4678911Z ##[debug]Entering Get-VstsWebProxy.
2024-11-11T12:56:32.4827379Z ##[debug]AGENT_VERSION: '3.246.0'
2024-11-11T12:56:32.4925444Z ##[debug]AGENT_PROXYURL (empty)
2024-11-11T12:56:32.5888204Z ##[debug]AGENT_PROXYUSERNAME (empty)
2024-11-11T12:56:32.5948664Z ##[debug]AGENT_PROXYPASSWORD (empty)
2024-11-11T12:56:32.6006979Z ##[debug]AGENT_PROXYBYPASSLIST (empty)
2024-11-11T12:56:32.6070756Z ##[debug]Leaving Get-VstsWebProxy.
2024-11-11T12:56:32.6115871Z ##[debug]Loading module from path 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\TlsHelper_\TlsHelper_.psm1'.
2024-11-11T12:56:32.6231161Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\TlsHelper_/module.json
2024-11-11T12:56:32.6330398Z ##[debug]Loaded 3 strings.
2024-11-11T12:56:32.6933695Z ##[debug]SYSTEM_CULTURE: 'en-US'
2024-11-11T12:56:32.6943311Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\TlsHelper_\Strings\resources.resjson\en-US\resources.resjson
2024-11-11T12:56:32.7059330Z ##[debug]Loaded 3 strings.
2024-11-11T12:56:32.7079419Z ##[debug]Exporting function 'Add-Tls12InSession'.
2024-11-11T12:56:32.7102132Z ##[debug]Exporting function 'Assert-TlsError'.
2024-11-11T12:56:32.7121137Z ##[debug]Importing function 'Add-Tls12InSession'.
2024-11-11T12:56:32.7189300Z ##[debug]Importing function 'Assert-TlsError'.
2024-11-11T12:56:33.0773097Z Added TLS 1.2 in session.
2024-11-11T12:56:33.1130705Z ##[debug]Exporting function 'Initialize-Azure'.
2024-11-11T12:56:33.1151678Z ##[debug]Exporting function 'CmdletHasMember'.
2024-11-11T12:56:33.1170782Z ##[debug]Exporting function 'Remove-EndpointSecrets'.
2024-11-11T12:56:33.1192358Z ##[debug]Exporting function 'Initialize-AzModule'.
2024-11-11T12:56:33.1212462Z ##[debug]Exporting function 'Disconnect-AzureAndClearContext'.
2024-11-11T12:56:33.1233626Z ##[debug]Exporting function 'Update-PSModulePathForHostedAgentWithLatestModule'.
2024-11-11T12:56:33.1257245Z ##[debug]Importing function 'CmdletHasMember'.
2024-11-11T12:56:33.1282137Z ##[debug]Importing function 'Disconnect-AzureAndClearContext'.
2024-11-11T12:56:33.1308084Z ##[debug]Importing function 'Initialize-AzModule'.
2024-11-11T12:56:33.1328277Z ##[debug]Importing function 'Initialize-Azure'.
2024-11-11T12:56:33.1351441Z ##[debug]Importing function 'Remove-EndpointSecrets'.
2024-11-11T12:56:33.1370903Z ##[debug]Importing function 'Update-PSModulePathForHostedAgentWithLatestModule'.
2024-11-11T12:56:33.1396986Z ##[debug]Loading module from path 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_\VstsAzureRestHelpers_.psm1'.
2024-11-11T12:56:33.1576965Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_/module.json
2024-11-11T12:56:33.1796340Z ##[debug]Loaded 12 strings.
2024-11-11T12:56:33.1830875Z ##[debug]SYSTEM_CULTURE: 'en-US'
2024-11-11T12:56:33.1855354Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_\Strings\resources.resjson\en-US\resources.resjson
2024-11-11T12:56:33.2074999Z ##[debug]Loaded 12 strings.
2024-11-11T12:56:33.2104828Z ##[debug]Importing function 'Add-Tls12InSession'.
2024-11-11T12:56:33.2126068Z ##[debug]Importing function 'Assert-TlsError'.
2024-11-11T12:56:33.2150421Z ##[debug]TLS 1.2 already present in session.
2024-11-11T12:56:33.2174674Z ##[debug]Exporting function 'Add-AzureSqlDatabaseServerFirewallRule'.
2024-11-11T12:56:33.2195669Z ##[debug]Exporting function 'Remove-AzureSqlDatabaseServerFirewallRule'.
2024-11-11T12:56:33.2216691Z ##[debug]Exporting function 'Get-AzStorageKeys'.
2024-11-11T12:56:33.2237592Z ##[debug]Exporting function 'Get-AzRMStorageKeys'.
2024-11-11T12:56:33.2259086Z ##[debug]Exporting function 'Get-AzRmVmCustomScriptExtension'.
2024-11-11T12:56:33.2282754Z ##[debug]Exporting function 'Remove-AzRmVmCustomScriptExtension'.
2024-11-11T12:56:33.2304009Z ##[debug]Exporting function 'Get-AzStorageAccount'.
2024-11-11T12:56:33.2323722Z ##[debug]Exporting function 'Get-AzRmStorageAccount'.
2024-11-11T12:56:33.2346169Z ##[debug]Exporting function 'Get-AzRmResourceGroup'.
2024-11-11T12:56:33.2366660Z ##[debug]Exporting function 'Get-AzureNetworkInterfaceDetails'.
2024-11-11T12:56:33.2387472Z ##[debug]Exporting function 'Get-AzurePublicIpAddressDetails'.
2024-11-11T12:56:33.2407063Z ##[debug]Exporting function 'Get-AzureLoadBalancersDetails'.
2024-11-11T12:56:33.2426336Z ##[debug]Exporting function 'Get-AzureLoadBalancerDetails'.
2024-11-11T12:56:33.2445226Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'.
2024-11-11T12:56:33.2466253Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'.
2024-11-11T12:56:33.2489411Z ##[debug]Exporting function 'Get-AzureRMAccessToken'.
2024-11-11T12:56:33.2509958Z ##[debug]Exporting function 'Get-AccessTokenMSALWithCustomScope'.
2024-11-11T12:56:33.2531168Z ##[debug]Importing function 'Add-AzureSqlDatabaseServerFirewallRule'.
2024-11-11T12:56:33.2554790Z ##[debug]Importing function 'Get-AccessTokenMSALWithCustomScope'.
2024-11-11T12:56:33.2580547Z ##[debug]Importing function 'Get-AzRmResourceGroup'.
2024-11-11T12:56:33.2607133Z ##[debug]Importing function 'Get-AzRmStorageAccount'.
2024-11-11T12:56:33.9952418Z ##[debug]Importing function 'Get-AzRMStorageKeys'.
2024-11-11T12:56:33.9953237Z ##[debug]Importing function 'Get-AzRmVmCustomScriptExtension'.
2024-11-11T12:56:33.9953858Z ##[debug]Importing function 'Get-AzStorageAccount'.
2024-11-11T12:56:33.9954457Z ##[debug]Importing function 'Get-AzStorageKeys'.
2024-11-11T12:56:33.9955025Z ##[debug]Importing function 'Get-AzureLoadBalancerDetails'.
2024-11-11T12:56:33.9955622Z ##[debug]Importing function 'Get-AzureLoadBalancersDetails'.
2024-11-11T12:56:33.9956207Z ##[debug]Importing function 'Get-AzureNetworkInterfaceDetails'.
2024-11-11T12:56:33.9957128Z ##[debug]Importing function 'Get-AzurePublicIpAddressDetails'.
2024-11-11T12:56:33.9957731Z ##[debug]Importing function 'Get-AzureRMAccessToken'.
2024-11-11T12:56:33.9958515Z ##[debug]Importing function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'.
2024-11-11T12:56:33.9959788Z ##[debug]Importing function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'.
2024-11-11T12:56:33.9960316Z ##[debug]Importing function 'Remove-AzRmVmCustomScriptExtension'.
2024-11-11T12:56:33.9960829Z ##[debug]Importing function 'Remove-AzureSqlDatabaseServerFirewallRule'.
2024-11-11T12:56:33.9961385Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0/Task.json
2024-11-11T12:56:33.9961909Z ##[debug]Loaded 25 strings.
2024-11-11T12:56:33.9962319Z ##[debug]SYSTEM_CULTURE: 'en-US'
2024-11-11T12:56:33.9962872Z ##[debug]Loading resource strings from: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\Strings\resources.resjson\en-US\resources.resjson
2024-11-11T12:56:33.9963691Z ##[debug]Loaded 25 strings.
2024-11-11T12:56:33.9964162Z ##[debug]ENDPOINT_URL_3163c192-0233-454a-8e86-1daae8f974c0: 'https://management.azure.com/'
2024-11-11T12:56:33.9964672Z ##[debug]ENDPOINT_AUTH_3163c192-0233-454a-8e86-1daae8f974c0: '********'
2024-11-11T12:56:33.9965999Z ##[debug]ENDPOINT_DATA_3163c192-0233-454a-8e86-1daae8f974c0: '{"environment":"AzureCloud","scopeLevel":"Subscription","creationMode":"Manual","subscriptionId":"dd1ebe0c-f16a-4190-85f5-c9f775a44f87","subscriptionName":"Partner In Benefits DEV/TEST","environmentUrl":"https://management.azure.com/","galleryUrl":"https://gallery.azure.com/","serviceManagementUrl":"https://management.core.windows.net/","resourceManagerUrl":"https://management.azure.com/","activeDirectoryAuthority":"https://login.microsoftonline.com/","environmentAuthorityUrl":"https://login.windows.net/","microsoftGraphUrl":"https://graph.microsoft.com/","managementPortalUrl":"https://manage.windowsazure.com/","armManagementPortalUrl":"https://portal.azure.com/","activeDirectoryServiceEndpointResourceId":"https://management.core.windows.net/","sqlDatabaseDnsSuffix":".database.windows.net","AzureKeyVaultDnsSuffix":"vault.azure.net","AzureKeyVaultServiceEndpointResourceId":"https://vault.azure.net","StorageEndpointSuffix":"core.windows.net","EnableAdfsAuthentication":"false"}'
2024-11-11T12:56:34.0213237Z ##[debug]Processed: ##vso[telemetry.publish area=TaskEndpointId;feature=SqlAzureDacpacDeployment]{"endpointId":"3163c192-0233-454a-8e86-1daae8f974c0","subscriptionId":"dd1ebe0c-f16a-4190-85f5-c9f775a44f87","serverName": "9c8f96f3fe7355baa49e861d6ba362fc2d9f787710c4ff939e8d5ed61410fe94","databaseName": "334daa138df2c2b76ce45eead3b7642ae90431b335987115a80b2f4fa8410bbc"}
2024-11-11T12:56:34.0214859Z ##[debug]Populating RepositorySourceLocation property for module SqlServer.
2024-11-11T12:56:34.0215443Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SqlServer\22.3.0\SqlNotebook.psm1'.
2024-11-11T12:56:34.0216040Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SqlServer\22.3.0\SqlServer.psm1'.
2024-11-11T12:56:34.0216633Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\SQLServer.psd1'.
2024-11-11T12:56:34.0217347Z ##[debug]Populating RepositorySourceLocation property for module SQLServer.
2024-11-11T12:56:34.0218023Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\SqlNotebook.psm1'.
2024-11-11T12:56:34.0218525Z ##[debug]Exporting function 'Invoke-SqlNotebook'.
2024-11-11T12:56:34.0218945Z ##[debug]Importing function 'Invoke-SqlNotebook'.
2024-11-11T12:56:34.0219424Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\SqlServer.psm1'.
2024-11-11T12:56:34.0958805Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\Microsoft.SqlServer.Management.PSProvider.dll'.
2024-11-11T12:56:34.5374378Z ##[debug]Importing cmdlet 'Convert-UrnToPath'.
2024-11-11T12:56:34.5398318Z ##[debug]Importing cmdlet 'ConvertTo-EncodedSqlName'.
2024-11-11T12:56:34.5418976Z ##[debug]Importing cmdlet 'ConvertFrom-EncodedSqlName'.
2024-11-11T12:56:34.5494632Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\Microsoft.SqlServer.Management.PSProvider.Ext.dll'.
2024-11-11T12:56:34.5549560Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\Microsoft.SqlServer.Management.PSSnapins.dll'.
2024-11-11T12:56:35.2672211Z ##[debug]Importing cmdlet 'Backup-SqlDatabase'.
2024-11-11T12:56:35.2701459Z ##[debug]Importing cmdlet 'Get-SqlBackupHistory'.
2024-11-11T12:56:35.2703153Z ##[debug]Importing cmdlet 'Restore-SqlDatabase'.
2024-11-11T12:56:35.3296556Z ##[debug]Importing cmdlet 'Get-SqlErrorLog'.
2024-11-11T12:56:35.3315931Z ##[debug]Importing cmdlet 'Set-SqlErrorLog'.
2024-11-11T12:56:35.3336832Z ##[debug]Importing cmdlet 'Invoke-PolicyEvaluation'.
2024-11-11T12:56:35.3354493Z ##[debug]Importing cmdlet 'Invoke-Sqlcmd'.
2024-11-11T12:56:35.3372368Z ##[debug]Importing cmdlet 'Get-SqlAgent'.
2024-11-11T12:56:35.3392882Z ##[debug]Importing cmdlet 'Get-SqlAgentJob'.
2024-11-11T12:56:35.3412906Z ##[debug]Importing cmdlet 'Get-SqlAgentJobHistory'.
2024-11-11T12:56:35.3430240Z ##[debug]Importing cmdlet 'Get-SqlAgentJobSchedule'.
2024-11-11T12:56:35.3451282Z ##[debug]Importing cmdlet 'Get-SqlAgentJobStep'.
2024-11-11T12:56:35.3469368Z ##[debug]Importing cmdlet 'Get-SqlAgentSchedule'.
2024-11-11T12:56:35.3492479Z ##[debug]Importing cmdlet 'Read-SqlTableData'.
2024-11-11T12:56:35.3511624Z ##[debug]Importing cmdlet 'Read-SqlViewData'.
2024-11-11T12:56:35.3532288Z ##[debug]Importing cmdlet 'Write-SqlTableData'.
2024-11-11T12:56:35.3556200Z ##[debug]Importing cmdlet 'Get-SqlSmartAdmin'.
2024-11-11T12:56:35.3600702Z ##[debug]Importing cmdlet 'Set-SqlSmartAdmin'.
2024-11-11T12:56:35.3622376Z ##[debug]Importing cmdlet 'Test-SqlSmartAdmin'.
2024-11-11T12:56:35.3623985Z ##[debug]Importing cmdlet 'Get-SqlCredential'.
2024-11-11T12:56:35.3643252Z ##[debug]Importing cmdlet 'Get-SqlInstance'.
2024-11-11T12:56:35.3658970Z ##[debug]Importing cmdlet 'New-SqlBackupEncryptionOption'.
2024-11-11T12:56:35.3676923Z ##[debug]Importing cmdlet 'New-SqlCredential'.
2024-11-11T12:56:35.3698547Z ##[debug]Importing cmdlet 'Remove-SqlCredential'.
2024-11-11T12:56:35.3715106Z ##[debug]Importing cmdlet 'Set-SqlCredential'.
2024-11-11T12:56:35.3734331Z ##[debug]Importing cmdlet 'Read-SqlXEvent'.
2024-11-11T12:56:35.3751496Z ##[debug]Importing cmdlet 'Add-SqlLogin'.
2024-11-11T12:56:35.3786534Z ##[debug]Importing cmdlet 'Get-SqlLogin'.
2024-11-11T12:56:35.3808266Z ##[debug]Importing cmdlet 'Remove-SqlLogin'.
2024-11-11T12:56:35.3830909Z ##[debug]Importing cmdlet 'Get-SqlDatabase'.
2024-11-11T12:56:35.3853317Z ##[debug]Importing cmdlet 'Add-SqlAvailabilityDatabase'.
2024-11-11T12:56:35.3870299Z ##[debug]Importing cmdlet 'Add-SqlAvailabilityGroupListenerStaticIp'.
2024-11-11T12:56:35.3887482Z ##[debug]Importing cmdlet 'Disable-SqlAlwaysOn'.
2024-11-11T12:56:35.3909206Z ##[debug]Importing cmdlet 'Enable-SqlAlwaysOn'.
2024-11-11T12:56:35.3934477Z ##[debug]Importing cmdlet 'Switch-SqlAvailabilityGroup'.
2024-11-11T12:56:35.3960125Z ##[debug]Importing cmdlet 'Grant-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:35.3981378Z ##[debug]Importing cmdlet 'Join-SqlAvailabilityGroup'.
2024-11-11T12:56:35.4000394Z ##[debug]Importing cmdlet 'New-SqlAvailabilityGroup'.
2024-11-11T12:56:35.4018897Z ##[debug]Importing cmdlet 'New-SqlAvailabilityGroupListener'.
2024-11-11T12:56:35.4038203Z ##[debug]Importing cmdlet 'New-SqlAvailabilityReplica'.
2024-11-11T12:56:35.4057984Z ##[debug]Importing cmdlet 'New-SqlHADREndpoint'.
2024-11-11T12:56:35.4078701Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityGroup'.
2024-11-11T12:56:35.4100298Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityDatabase'.
2024-11-11T12:56:35.4120618Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityReplica'.
2024-11-11T12:56:35.4142676Z ##[debug]Importing cmdlet 'Resume-SqlAvailabilityDatabase'.
2024-11-11T12:56:35.4162143Z ##[debug]Importing cmdlet 'Revoke-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:35.4179198Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityGroup'.
2024-11-11T12:56:35.4202646Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityGroupListener'.
2024-11-11T12:56:35.4221021Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityReplica'.
2024-11-11T12:56:35.4242349Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityReplicaRoleToSecondary'.
2024-11-11T12:56:35.4261522Z ##[debug]Importing cmdlet 'Set-SqlHADREndpoint'.
2024-11-11T12:56:35.4278067Z ##[debug]Importing cmdlet 'Suspend-SqlAvailabilityDatabase'.
2024-11-11T12:56:35.4298990Z ##[debug]Importing cmdlet 'Test-SqlAvailabilityGroup'.
2024-11-11T12:56:35.4318943Z ##[debug]Importing cmdlet 'Test-SqlAvailabilityReplica'.
2024-11-11T12:56:35.4334225Z ##[debug]Agent environment resources - Disk: D:\ Available 12376.56 MB out of 14334.00 MB, Memory: Used 2091.00 MB out of 7167.00 MB, CPU: Usage 53.00%
2024-11-11T12:56:35.4337248Z ##[debug]Importing cmdlet 'Test-SqlDatabaseReplicaState'.
2024-11-11T12:56:35.4355643Z ##[debug]Importing cmdlet 'Get-SqlSensitivityClassification'.
2024-11-11T12:56:35.4374269Z ##[debug]Importing cmdlet 'Get-SqlSensitivityRecommendations'.
2024-11-11T12:56:35.4395295Z ##[debug]Importing cmdlet 'Remove-SqlSensitivityClassification'.
2024-11-11T12:56:35.4417145Z ##[debug]Importing cmdlet 'Set-SqlSensitivityClassification'.
2024-11-11T12:56:35.4433964Z ##[debug]Importing cmdlet 'Add-SqlAzureAuthenticationContext'.
2024-11-11T12:56:35.4453209Z ##[debug]Importing cmdlet 'Add-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:35.4469954Z ##[debug]Importing cmdlet 'Complete-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:35.4490193Z ##[debug]Importing cmdlet 'Get-SqlColumnEncryptionKey'.
2024-11-11T12:56:35.4510174Z ##[debug]Importing cmdlet 'Get-SqlColumnMasterKey'.
2024-11-11T12:56:35.4529248Z ##[debug]Importing cmdlet 'Invoke-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:35.4547521Z ##[debug]Importing cmdlet 'New-SqlAzureKeyVaultColumnMasterKeySettings'.
2024-11-11T12:56:35.4571830Z ##[debug]Importing cmdlet 'New-SqlCertificateStoreColumnMasterKeySettings'.
2024-11-11T12:56:35.4589900Z ##[debug]Importing cmdlet 'New-SqlCngColumnMasterKeySettings'.
2024-11-11T12:56:35.4609756Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionKey'.
2024-11-11T12:56:35.4627066Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionKeyEncryptedValue'.
2024-11-11T12:56:35.4648199Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionSettings'.
2024-11-11T12:56:35.4665521Z ##[debug]Importing cmdlet 'New-SqlColumnMasterKey'.
2024-11-11T12:56:35.4682470Z ##[debug]Importing cmdlet 'New-SqlColumnMasterKeySettings'.
2024-11-11T12:56:35.4702221Z ##[debug]Importing cmdlet 'New-SqlCspColumnMasterKeySettings'.
2024-11-11T12:56:35.4720904Z ##[debug]Importing cmdlet 'Remove-SqlColumnEncryptionKey'.
2024-11-11T12:56:35.4739449Z ##[debug]Importing cmdlet 'Remove-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:35.4757412Z ##[debug]Importing cmdlet 'Remove-SqlColumnMasterKey'.
2024-11-11T12:56:35.4774820Z ##[debug]Importing cmdlet 'Set-SqlColumnEncryption'.
2024-11-11T12:56:35.4817445Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\Microsoft.AnalysisServices.PowerShell.Cmdlets.dll'.
2024-11-11T12:56:35.6650586Z ##[debug]Importing cmdlet 'Add-RoleMember'.
2024-11-11T12:56:35.6670254Z ##[debug]Importing cmdlet 'Backup-ASDatabase'.
2024-11-11T12:56:35.6692957Z ##[debug]Importing cmdlet 'Invoke-ASCmd'.
2024-11-11T12:56:35.6711303Z ##[debug]Importing cmdlet 'Merge-Partition'.
2024-11-11T12:56:35.6733755Z ##[debug]Importing cmdlet 'Invoke-ProcessCube'.
2024-11-11T12:56:35.6757964Z ##[debug]Importing cmdlet 'Invoke-ProcessASDatabase'.
2024-11-11T12:56:35.6779636Z ##[debug]Importing cmdlet 'Invoke-ProcessDimension'.
2024-11-11T12:56:35.6798772Z ##[debug]Importing cmdlet 'Invoke-ProcessPartition'.
2024-11-11T12:56:35.6818049Z ##[debug]Importing cmdlet 'Invoke-ProcessTable'.
2024-11-11T12:56:35.6838783Z ##[debug]Importing cmdlet 'Remove-RoleMember'.
2024-11-11T12:56:35.6857023Z ##[debug]Importing cmdlet 'Restore-ASDatabase'.
2024-11-11T12:56:35.6875640Z ##[debug]Importing cmdlet 'New-RestoreFolder'.
2024-11-11T12:56:35.6894832Z ##[debug]Importing cmdlet 'New-RestoreLocation'.
2024-11-11T12:56:35.6927883Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\Microsoft.SqlServer.Assessment.Cmdlets.dll'.
2024-11-11T12:56:35.7710854Z ##[debug]Importing cmdlet 'Get-SqlAssessmentItem'.
2024-11-11T12:56:35.7729943Z ##[debug]Importing cmdlet 'Invoke-SqlAssessment'.
2024-11-11T12:56:35.7762123Z ##[debug]Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\SqlServerPostScript.ps1'.
2024-11-11T12:56:35.7904301Z ##[debug]Dot-sourcing the script file 'C:\Program Files\WindowsPowerShell\Modules\SQLServer\22.3.0\SqlServerPostScript.ps1'.
2024-11-11T12:56:39.8650890Z ##[debug]Exporting function 'Invoke-SqlNotebook'.
2024-11-11T12:56:39.8670013Z ##[debug]Exporting function 'SQLSERVER:'.
2024-11-11T12:56:39.8691441Z ##[debug]Exporting cmdlet 'Convert-UrnToPath'.
2024-11-11T12:56:39.8710839Z ##[debug]Exporting cmdlet 'ConvertTo-EncodedSqlName'.
2024-11-11T12:56:39.8731637Z ##[debug]Exporting cmdlet 'ConvertFrom-EncodedSqlName'.
2024-11-11T12:56:39.8750151Z ##[debug]Exporting cmdlet 'Backup-SqlDatabase'.
2024-11-11T12:56:39.8772044Z ##[debug]Exporting cmdlet 'Get-SqlBackupHistory'.
2024-11-11T12:56:39.8792727Z ##[debug]Exporting cmdlet 'Restore-SqlDatabase'.
2024-11-11T12:56:39.8815520Z ##[debug]Exporting cmdlet 'Get-SqlErrorLog'.
2024-11-11T12:56:39.8834023Z ##[debug]Exporting cmdlet 'Set-SqlErrorLog'.
2024-11-11T12:56:39.8855790Z ##[debug]Exporting cmdlet 'Invoke-PolicyEvaluation'.
2024-11-11T12:56:39.8874576Z ##[debug]Exporting cmdlet 'Invoke-Sqlcmd'.
2024-11-11T12:56:39.8894007Z ##[debug]Exporting cmdlet 'Get-SqlAgent'.
2024-11-11T12:56:39.8915641Z ##[debug]Exporting cmdlet 'Get-SqlAgentJob'.
2024-11-11T12:56:39.8933463Z ##[debug]Exporting cmdlet 'Get-SqlAgentJobHistory'.
2024-11-11T12:56:39.8955229Z ##[debug]Exporting cmdlet 'Get-SqlAgentJobSchedule'.
2024-11-11T12:56:39.8977375Z ##[debug]Exporting cmdlet 'Get-SqlAgentJobStep'.
2024-11-11T12:56:39.8995613Z ##[debug]Exporting cmdlet 'Get-SqlAgentSchedule'.
2024-11-11T12:56:39.9014449Z ##[debug]Exporting cmdlet 'Read-SqlTableData'.
2024-11-11T12:56:39.9033504Z ##[debug]Exporting cmdlet 'Read-SqlViewData'.
2024-11-11T12:56:39.9052803Z ##[debug]Exporting cmdlet 'Write-SqlTableData'.
2024-11-11T12:56:39.9076114Z ##[debug]Exporting cmdlet 'Get-SqlSmartAdmin'.
2024-11-11T12:56:39.9095812Z ##[debug]Exporting cmdlet 'Set-SqlSmartAdmin'.
2024-11-11T12:56:39.9116471Z ##[debug]Exporting cmdlet 'Test-SqlSmartAdmin'.
2024-11-11T12:56:39.9202622Z ##[debug]Exporting cmdlet 'Get-SqlCredential'.
2024-11-11T12:56:39.9203650Z ##[debug]Exporting cmdlet 'Get-SqlInstance'.
2024-11-11T12:56:39.9204524Z ##[debug]Exporting cmdlet 'New-SqlBackupEncryptionOption'.
2024-11-11T12:56:39.9205343Z ##[debug]Exporting cmdlet 'New-SqlCredential'.
2024-11-11T12:56:39.9211778Z ##[debug]Exporting cmdlet 'Remove-SqlCredential'.
2024-11-11T12:56:39.9227495Z ##[debug]Exporting cmdlet 'Set-SqlCredential'.
2024-11-11T12:56:39.9246873Z ##[debug]Exporting cmdlet 'Read-SqlXEvent'.
2024-11-11T12:56:39.9271830Z ##[debug]Exporting cmdlet 'Add-SqlLogin'.
2024-11-11T12:56:39.9300782Z ##[debug]Exporting cmdlet 'Get-SqlLogin'.
2024-11-11T12:56:39.9321733Z ##[debug]Exporting cmdlet 'Remove-SqlLogin'.
2024-11-11T12:56:39.9341950Z ##[debug]Exporting cmdlet 'Get-SqlDatabase'.
2024-11-11T12:56:39.9364257Z ##[debug]Exporting cmdlet 'Add-SqlAvailabilityDatabase'.
2024-11-11T12:56:39.9382988Z ##[debug]Exporting cmdlet 'Add-SqlAvailabilityGroupListenerStaticIp'.
2024-11-11T12:56:39.9402989Z ##[debug]Exporting cmdlet 'Disable-SqlAlwaysOn'.
2024-11-11T12:56:39.9425373Z ##[debug]Exporting cmdlet 'Enable-SqlAlwaysOn'.
2024-11-11T12:56:39.9445533Z ##[debug]Exporting cmdlet 'Switch-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9464650Z ##[debug]Exporting cmdlet 'Grant-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:39.9482700Z ##[debug]Exporting cmdlet 'Join-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9502977Z ##[debug]Exporting cmdlet 'New-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9522522Z ##[debug]Exporting cmdlet 'New-SqlAvailabilityGroupListener'.
2024-11-11T12:56:39.9540695Z ##[debug]Exporting cmdlet 'New-SqlAvailabilityReplica'.
2024-11-11T12:56:39.9562029Z ##[debug]Exporting cmdlet 'New-SqlHADREndpoint'.
2024-11-11T12:56:39.9583735Z ##[debug]Exporting cmdlet 'Remove-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9609388Z ##[debug]Exporting cmdlet 'Remove-SqlAvailabilityDatabase'.
2024-11-11T12:56:39.9627053Z ##[debug]Exporting cmdlet 'Remove-SqlAvailabilityReplica'.
2024-11-11T12:56:39.9644238Z ##[debug]Exporting cmdlet 'Resume-SqlAvailabilityDatabase'.
2024-11-11T12:56:39.9666062Z ##[debug]Exporting cmdlet 'Revoke-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:39.9684058Z ##[debug]Exporting cmdlet 'Set-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9702537Z ##[debug]Exporting cmdlet 'Set-SqlAvailabilityGroupListener'.
2024-11-11T12:56:39.9723421Z ##[debug]Exporting cmdlet 'Set-SqlAvailabilityReplica'.
2024-11-11T12:56:39.9743395Z ##[debug]Exporting cmdlet 'Set-SqlAvailabilityReplicaRoleToSecondary'.
2024-11-11T12:56:39.9764661Z ##[debug]Exporting cmdlet 'Set-SqlHADREndpoint'.
2024-11-11T12:56:39.9784195Z ##[debug]Exporting cmdlet 'Suspend-SqlAvailabilityDatabase'.
2024-11-11T12:56:39.9801506Z ##[debug]Exporting cmdlet 'Test-SqlAvailabilityGroup'.
2024-11-11T12:56:39.9823069Z ##[debug]Exporting cmdlet 'Test-SqlAvailabilityReplica'.
2024-11-11T12:56:39.9843378Z ##[debug]Exporting cmdlet 'Test-SqlDatabaseReplicaState'.
2024-11-11T12:56:39.9861927Z ##[debug]Exporting cmdlet 'Get-SqlSensitivityClassification'.
2024-11-11T12:56:39.9883761Z ##[debug]Exporting cmdlet 'Get-SqlSensitivityRecommendations'.
2024-11-11T12:56:39.9903233Z ##[debug]Exporting cmdlet 'Remove-SqlSensitivityClassification'.
2024-11-11T12:56:39.9925181Z ##[debug]Exporting cmdlet 'Set-SqlSensitivityClassification'.
2024-11-11T12:56:39.9944836Z ##[debug]Exporting cmdlet 'Add-SqlAzureAuthenticationContext'.
2024-11-11T12:56:39.9963478Z ##[debug]Exporting cmdlet 'Add-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:39.9983165Z ##[debug]Exporting cmdlet 'Complete-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:40.0001456Z ##[debug]Exporting cmdlet 'Get-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.0019712Z ##[debug]Exporting cmdlet 'Get-SqlColumnMasterKey'.
2024-11-11T12:56:40.0042017Z ##[debug]Exporting cmdlet 'Invoke-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:40.0060746Z ##[debug]Exporting cmdlet 'New-SqlAzureKeyVaultColumnMasterKeySettings'.
2024-11-11T12:56:40.0083172Z ##[debug]Exporting cmdlet 'New-SqlCertificateStoreColumnMasterKeySettings'.
2024-11-11T12:56:40.0103737Z ##[debug]Exporting cmdlet 'New-SqlCngColumnMasterKeySettings'.
2024-11-11T12:56:40.0125408Z ##[debug]Exporting cmdlet 'New-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.0142984Z ##[debug]Exporting cmdlet 'New-SqlColumnEncryptionKeyEncryptedValue'.
2024-11-11T12:56:40.0161510Z ##[debug]Exporting cmdlet 'New-SqlColumnEncryptionSettings'.
2024-11-11T12:56:40.0182967Z ##[debug]Exporting cmdlet 'New-SqlColumnMasterKey'.
2024-11-11T12:56:40.0204208Z ##[debug]Exporting cmdlet 'New-SqlColumnMasterKeySettings'.
2024-11-11T12:56:40.0223552Z ##[debug]Exporting cmdlet 'New-SqlCspColumnMasterKeySettings'.
2024-11-11T12:56:40.0243057Z ##[debug]Exporting cmdlet 'Remove-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.0261142Z ##[debug]Exporting cmdlet 'Remove-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:40.0283029Z ##[debug]Exporting cmdlet 'Remove-SqlColumnMasterKey'.
2024-11-11T12:56:40.0301709Z ##[debug]Exporting cmdlet 'Set-SqlColumnEncryption'.
2024-11-11T12:56:40.0318827Z ##[debug]Exporting cmdlet 'Add-RoleMember'.
2024-11-11T12:56:40.0336902Z ##[debug]Exporting cmdlet 'Backup-ASDatabase'.
2024-11-11T12:56:40.0357726Z ##[debug]Exporting cmdlet 'Invoke-ASCmd'.
2024-11-11T12:56:40.0377273Z ##[debug]Exporting cmdlet 'Merge-Partition'.
2024-11-11T12:56:40.0402047Z ##[debug]Exporting cmdlet 'Invoke-ProcessCube'.
2024-11-11T12:56:40.0421139Z ##[debug]Exporting cmdlet 'Invoke-ProcessASDatabase'.
2024-11-11T12:56:40.0441297Z ##[debug]Exporting cmdlet 'Invoke-ProcessDimension'.
2024-11-11T12:56:40.0458697Z ##[debug]Exporting cmdlet 'Invoke-ProcessPartition'.
2024-11-11T12:56:40.0479576Z ##[debug]Exporting cmdlet 'Invoke-ProcessTable'.
2024-11-11T12:56:40.0497876Z ##[debug]Exporting cmdlet 'Remove-RoleMember'.
2024-11-11T12:56:40.0519596Z ##[debug]Exporting cmdlet 'Restore-ASDatabase'.
2024-11-11T12:56:40.0537946Z ##[debug]Exporting cmdlet 'New-RestoreFolder'.
2024-11-11T12:56:40.0561445Z ##[debug]Exporting cmdlet 'New-RestoreLocation'.
2024-11-11T12:56:40.0586185Z ##[debug]Exporting cmdlet 'Get-SqlAssessmentItem'.
2024-11-11T12:56:40.0605488Z ##[debug]Exporting cmdlet 'Invoke-SqlAssessment'.
2024-11-11T12:56:40.0627893Z ##[debug]Exporting alias 'Encode-SqlName'.
2024-11-11T12:56:40.0648171Z ##[debug]Exporting alias 'Decode-SqlName'.
2024-11-11T12:56:40.0700513Z ##[debug]Importing cmdlet 'Add-RoleMember'.
2024-11-11T12:56:40.0721030Z ##[debug]Importing cmdlet 'Add-SqlAvailabilityDatabase'.
2024-11-11T12:56:40.0739142Z ##[debug]Importing cmdlet 'Add-SqlAvailabilityGroupListenerStaticIp'.
2024-11-11T12:56:40.0759846Z ##[debug]Importing cmdlet 'Add-SqlAzureAuthenticationContext'.
2024-11-11T12:56:40.0780437Z ##[debug]Importing cmdlet 'Add-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:40.0799627Z ##[debug]Importing cmdlet 'Add-SqlLogin'.
2024-11-11T12:56:40.0820596Z ##[debug]Importing cmdlet 'Backup-ASDatabase'.
2024-11-11T12:56:40.0839465Z ##[debug]Importing cmdlet 'Backup-SqlDatabase'.
2024-11-11T12:56:40.0862477Z ##[debug]Importing cmdlet 'Complete-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:40.0883385Z ##[debug]Importing cmdlet 'Convert-UrnToPath'.
2024-11-11T12:56:40.0904100Z ##[debug]Importing cmdlet 'ConvertFrom-EncodedSqlName'.
2024-11-11T12:56:40.0922365Z ##[debug]Importing cmdlet 'ConvertTo-EncodedSqlName'.
2024-11-11T12:56:40.0942182Z ##[debug]Importing cmdlet 'Disable-SqlAlwaysOn'.
2024-11-11T12:56:40.0963564Z ##[debug]Importing cmdlet 'Enable-SqlAlwaysOn'.
2024-11-11T12:56:40.0987076Z ##[debug]Importing cmdlet 'Get-SqlAgent'.
2024-11-11T12:56:40.1006272Z ##[debug]Importing cmdlet 'Get-SqlAgentJob'.
2024-11-11T12:56:40.1026759Z ##[debug]Importing cmdlet 'Get-SqlAgentJobHistory'.
2024-11-11T12:56:40.1046009Z ##[debug]Importing cmdlet 'Get-SqlAgentJobSchedule'.
2024-11-11T12:56:40.1065513Z ##[debug]Importing cmdlet 'Get-SqlAgentJobStep'.
2024-11-11T12:56:40.1085962Z ##[debug]Importing cmdlet 'Get-SqlAgentSchedule'.
2024-11-11T12:56:40.1105604Z ##[debug]Importing cmdlet 'Get-SqlAssessmentItem'.
2024-11-11T12:56:40.1137319Z ##[debug]Importing cmdlet 'Get-SqlBackupHistory'.
2024-11-11T12:56:40.1154270Z ##[debug]Importing cmdlet 'Get-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.1172091Z ##[debug]Importing cmdlet 'Get-SqlColumnMasterKey'.
2024-11-11T12:56:40.1194058Z ##[debug]Importing cmdlet 'Get-SqlCredential'.
2024-11-11T12:56:40.1211722Z ##[debug]Importing cmdlet 'Get-SqlDatabase'.
2024-11-11T12:56:40.1232651Z ##[debug]Importing cmdlet 'Get-SqlErrorLog'.
2024-11-11T12:56:40.1250507Z ##[debug]Importing cmdlet 'Get-SqlInstance'.
2024-11-11T12:56:40.1268926Z ##[debug]Importing cmdlet 'Get-SqlLogin'.
2024-11-11T12:56:40.1291064Z ##[debug]Importing cmdlet 'Get-SqlSensitivityClassification'.
2024-11-11T12:56:40.1309690Z ##[debug]Importing cmdlet 'Get-SqlSensitivityRecommendations'.
2024-11-11T12:56:40.1328047Z ##[debug]Importing cmdlet 'Get-SqlSmartAdmin'.
2024-11-11T12:56:40.1348436Z ##[debug]Importing cmdlet 'Grant-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:40.1366925Z ##[debug]Importing cmdlet 'Invoke-ASCmd'.
2024-11-11T12:56:40.1390785Z ##[debug]Importing cmdlet 'Invoke-PolicyEvaluation'.
2024-11-11T12:56:40.1410576Z ##[debug]Importing cmdlet 'Invoke-ProcessASDatabase'.
2024-11-11T12:56:40.1433429Z ##[debug]Importing cmdlet 'Invoke-ProcessCube'.
2024-11-11T12:56:40.1459017Z ##[debug]Importing cmdlet 'Invoke-ProcessDimension'.
2024-11-11T12:56:40.1478122Z ##[debug]Importing cmdlet 'Invoke-ProcessPartition'.
2024-11-11T12:56:40.1509312Z ##[debug]Importing cmdlet 'Invoke-ProcessTable'.
2024-11-11T12:56:40.1532057Z ##[debug]Importing cmdlet 'Invoke-SqlAssessment'.
2024-11-11T12:56:40.1551300Z ##[debug]Importing cmdlet 'Invoke-Sqlcmd'.
2024-11-11T12:56:40.1570319Z ##[debug]Importing cmdlet 'Invoke-SqlColumnMasterKeyRotation'.
2024-11-11T12:56:40.1590360Z ##[debug]Importing cmdlet 'Join-SqlAvailabilityGroup'.
2024-11-11T12:56:40.1611144Z ##[debug]Importing cmdlet 'Merge-Partition'.
2024-11-11T12:56:40.1628030Z ##[debug]Importing cmdlet 'New-RestoreFolder'.
2024-11-11T12:56:40.1647818Z ##[debug]Importing cmdlet 'New-RestoreLocation'.
2024-11-11T12:56:40.1666866Z ##[debug]Importing cmdlet 'New-SqlAvailabilityGroup'.
2024-11-11T12:56:40.1686167Z ##[debug]Importing cmdlet 'New-SqlAvailabilityGroupListener'.
2024-11-11T12:56:40.1705650Z ##[debug]Importing cmdlet 'New-SqlAvailabilityReplica'.
2024-11-11T12:56:40.1726265Z ##[debug]Importing cmdlet 'New-SqlAzureKeyVaultColumnMasterKeySettings'.
2024-11-11T12:56:40.1745922Z ##[debug]Importing cmdlet 'New-SqlBackupEncryptionOption'.
2024-11-11T12:56:40.1766629Z ##[debug]Importing cmdlet 'New-SqlCertificateStoreColumnMasterKeySettings'.
2024-11-11T12:56:40.1786357Z ##[debug]Importing cmdlet 'New-SqlCngColumnMasterKeySettings'.
2024-11-11T12:56:40.1807883Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.1826646Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionKeyEncryptedValue'.
2024-11-11T12:56:40.1844381Z ##[debug]Importing cmdlet 'New-SqlColumnEncryptionSettings'.
2024-11-11T12:56:40.1862065Z ##[debug]Importing cmdlet 'New-SqlColumnMasterKey'.
2024-11-11T12:56:40.1880580Z ##[debug]Importing cmdlet 'New-SqlColumnMasterKeySettings'.
2024-11-11T12:56:40.2017001Z ##[debug]Importing cmdlet 'New-SqlCredential'.
2024-11-11T12:56:40.2035321Z ##[debug]Importing cmdlet 'New-SqlCspColumnMasterKeySettings'.
2024-11-11T12:56:40.2053729Z ##[debug]Importing cmdlet 'New-SqlHADREndpoint'.
2024-11-11T12:56:40.2075062Z ##[debug]Importing cmdlet 'Read-SqlTableData'.
2024-11-11T12:56:40.2097077Z ##[debug]Importing cmdlet 'Read-SqlViewData'.
2024-11-11T12:56:40.2116227Z ##[debug]Importing cmdlet 'Read-SqlXEvent'.
2024-11-11T12:56:40.2138450Z ##[debug]Importing cmdlet 'Remove-RoleMember'.
2024-11-11T12:56:40.2157566Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityDatabase'.
2024-11-11T12:56:40.2176107Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityGroup'.
2024-11-11T12:56:40.2194839Z ##[debug]Importing cmdlet 'Remove-SqlAvailabilityReplica'.
2024-11-11T12:56:40.2214579Z ##[debug]Importing cmdlet 'Remove-SqlColumnEncryptionKey'.
2024-11-11T12:56:40.2234461Z ##[debug]Importing cmdlet 'Remove-SqlColumnEncryptionKeyValue'.
2024-11-11T12:56:40.2252464Z ##[debug]Importing cmdlet 'Remove-SqlColumnMasterKey'.
2024-11-11T12:56:40.2269905Z ##[debug]Importing cmdlet 'Remove-SqlCredential'.
2024-11-11T12:56:40.2292781Z ##[debug]Importing cmdlet 'Remove-SqlLogin'.
2024-11-11T12:56:40.2315668Z ##[debug]Importing cmdlet 'Remove-SqlSensitivityClassification'.
2024-11-11T12:56:40.2333004Z ##[debug]Importing cmdlet 'Restore-ASDatabase'.
2024-11-11T12:56:40.2350756Z ##[debug]Importing cmdlet 'Restore-SqlDatabase'.
2024-11-11T12:56:40.2369327Z ##[debug]Importing cmdlet 'Resume-SqlAvailabilityDatabase'.
2024-11-11T12:56:40.2392071Z ##[debug]Importing cmdlet 'Revoke-SqlAvailabilityGroupCreateAnyDatabase'.
2024-11-11T12:56:40.2412482Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityGroup'.
2024-11-11T12:56:40.2434830Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityGroupListener'.
2024-11-11T12:56:40.2458046Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityReplica'.
2024-11-11T12:56:40.2478448Z ##[debug]Importing cmdlet 'Set-SqlAvailabilityReplicaRoleToSecondary'.
2024-11-11T12:56:40.2515062Z ##[debug]Importing cmdlet 'Set-SqlColumnEncryption'.
2024-11-11T12:56:40.2537264Z ##[debug]Importing cmdlet 'Set-SqlCredential'.
2024-11-11T12:56:40.2556733Z ##[debug]Importing cmdlet 'Set-SqlErrorLog'.
2024-11-11T12:56:40.2575469Z ##[debug]Importing cmdlet 'Set-SqlHADREndpoint'.
2024-11-11T12:56:40.2593640Z ##[debug]Importing cmdlet 'Set-SqlSensitivityClassification'.
2024-11-11T12:56:40.2614328Z ##[debug]Importing cmdlet 'Set-SqlSmartAdmin'.
2024-11-11T12:56:40.2635840Z ##[debug]Importing cmdlet 'Suspend-SqlAvailabilityDatabase'.
2024-11-11T12:56:40.2653796Z ##[debug]Importing cmdlet 'Switch-SqlAvailabilityGroup'.
2024-11-11T12:56:40.2671499Z ##[debug]Importing cmdlet 'Test-SqlAvailabilityGroup'.
2024-11-11T12:56:40.2691628Z ##[debug]Importing cmdlet 'Test-SqlAvailabilityReplica'.
2024-11-11T12:56:40.2712703Z ##[debug]Importing cmdlet 'Test-SqlDatabaseReplicaState'.
2024-11-11T12:56:40.2732604Z ##[debug]Importing cmdlet 'Test-SqlSmartAdmin'.
2024-11-11T12:56:40.2751823Z ##[debug]Importing cmdlet 'Write-SqlTableData'.
2024-11-11T12:56:40.2773105Z ##[debug]Importing function 'Invoke-SqlNotebook'.
2024-11-11T12:56:40.2794028Z ##[debug]Importing function 'SQLSERVER:'.
2024-11-11T12:56:40.2814007Z ##[debug]Importing alias 'Decode-SqlName'.
2024-11-11T12:56:40.2832364Z ##[debug]Importing alias 'Encode-SqlName'.
2024-11-11T12:56:40.2877151Z ##[debug]Imported SQLServer PS module.
2024-11-11T12:56:40.3156987Z ##[debug]Get-AzureRMAccessToken - started - endpoint=@{Url=https://management.azure.com/; Data=; Auth=} - scheme=WorkloadIdentityFederation
2024-11-11T12:56:40.3249185Z ##[debug]USE_MSAL: 'true'
2024-11-11T12:56:40.3268318Z ##[debug]MSAL - USE_MSAL override is found: true
2024-11-11T12:56:40.3308560Z ##[debug]MSAL - useMSAL = True
2024-11-11T12:56:40.3630796Z ##[debug]MSAL - Get-EnvironmentAuthUrl - endpoint=@{Url=https://management.azure.com/; Data=; Auth=}
2024-11-11T12:56:40.3656119Z ##[debug]MSAL - Get-EnvironmentAuthUrl - useMSAL=True
2024-11-11T12:56:40.3675013Z ##[debug]MSAL - Get-EnvironmentAuthUrl - envAuthUrl=https://login.microsoftonline.com/
2024-11-11T12:56:40.4499423Z ##[debug]Agent environment resources - Disk: D:\ Available 12376.56 MB out of 14334.00 MB, Memory: Used 2123.00 MB out of 7167.00 MB, CPU: Usage 21.00%
2024-11-11T12:56:40.5175088Z ##[debug]MSAL - WorkloadIdentityFederation is used
2024-11-11T12:56:40.5209768Z ##[debug]ENDPOINT_URL_SystemVssConnection: 'https://dev.azure.com/mad-it/'
2024-11-11T12:56:40.5228907Z ##[debug]ENDPOINT_AUTH_SystemVssConnection: '********'
2024-11-11T12:56:40.5255286Z ##[debug]ENDPOINT_DATA_SystemVssConnection (empty)
2024-11-11T12:56:40.8312196Z ##[debug]Trying again to construct the HTTP client.
2024-11-11T12:56:40.8635041Z ##[debug]SYSTEM_COLLECTIONURI: 'https://dev.azure.com/mad-it/'
2024-11-11T12:56:40.8888606Z ##[debug]Entering Get-WebProxy.
2024-11-11T12:56:40.8961516Z ##[debug]AGENT_VERSION: '3.246.0'
2024-11-11T12:56:40.8991355Z ##[debug]AGENT_PROXYURL (empty)
2024-11-11T12:56:40.9020885Z ##[debug]AGENT_PROXYUSERNAME (empty)
2024-11-11T12:56:40.9048867Z ##[debug]AGENT_PROXYPASSWORD (empty)
2024-11-11T12:56:40.9074990Z ##[debug]AGENT_PROXYBYPASSLIST (empty)
2024-11-11T12:56:40.9108432Z ##[debug]Leaving Get-WebProxy.
2024-11-11T12:56:40.9149049Z ##[debug]Entering Get-VstsVssHttpClient.
2024-11-11T12:56:40.9259365Z ##[debug] OMDirectory: 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_'
2024-11-11T12:56:40.9279962Z ##[debug] TypeName: 'Microsoft.TeamFoundation.DistributedTask.WebApi.TaskHttpClient'
2024-11-11T12:56:40.9324249Z ##[debug] VssCredentials: 'Microsoft.VisualStudio.Services.Common.VssCredentials'
2024-11-11T12:56:40.9345459Z ##[debug] Uri: 'https://dev.azure.com/mad-it/'
2024-11-11T12:56:40.9513368Z ##[debug]Entering Get-OMType.
2024-11-11T12:56:40.9532980Z ##[debug] TypeName: 'Microsoft.TeamFoundation.DistributedTask.WebApi.TaskHttpClient'
2024-11-11T12:56:40.9553565Z ##[debug] OMKind: 'WebApi'
2024-11-11T12:56:40.9577385Z ##[debug] OMDirectory: 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_'
2024-11-11T12:56:40.9624016Z ##[debug] Require: 'True'
2024-11-11T12:56:40.9650071Z ##[debug]Testing whether type can be loaded: 'Microsoft.TeamFoundation.DistributedTask.WebApi.TaskHttpClient'
2024-11-11T12:56:40.9764819Z ##[debug]Unable to resolve assembly name 'System.Management.Automation.resources, Version=3.0.0.0, Culture=en-US, PublicKeyToken=31bf3856ad364e35'
2024-11-11T12:56:40.9825874Z ##[debug]Unable to resolve assembly name 'System.Management.Automation.resources, Version=3.0.0.0, Culture=en-US, PublicKeyToken=31bf3856ad364e35'
2024-11-11T12:56:41.0440791Z ##[debug]The type was not loaded.
2024-11-11T12:56:41.0552236Z ##[debug]Testing leaf path: 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_\Microsoft.TeamFoundation.DistributedTask.WebApi.WebApi.dll'
2024-11-11T12:56:41.0583345Z ##[debug]Not found.
2024-11-11T12:56:41.0605146Z ##[debug]Testing leaf path: 'D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_\Microsoft.TeamFoundation.DistributedTask.WebApi.dll'
2024-11-11T12:56:41.0631914Z ##[debug]Loading assembly: D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\ps_modules\VstsAzureRestHelpers_\Microsoft.TeamFoundation.DistributedTask.WebApi.dll
2024-11-11T12:56:41.1959672Z ##[debug]Testing whether type can be loaded: 'Microsoft.TeamFoundation.DistributedTask.WebApi.TaskHttpClient'
2024-11-11T12:56:41.1995958Z ##[debug]The type was loaded successfully.
2024-11-11T12:56:41.2032774Z ##[debug]Leaving Get-OMType.
2024-11-11T12:56:41.2092046Z ##[debug]Constructing HTTP client.
2024-11-11T12:56:41.2592280Z ##[debug]Leaving Get-VstsVssHttpClient.
2024-11-11T12:56:41.2621003Z ##[debug]Removing assemlby resolver.
2024-11-11T12:56:41.2703123Z ##[debug]SYSTEM_PLANID: '17219813-4c72-4e62-9c9b-a0e420077125'
2024-11-11T12:56:41.2763363Z ##[debug]SYSTEM_JOBID: '56a927c8-498a-5c53-8a01-56dac50afa8c'
2024-11-11T12:56:41.2817581Z ##[debug]SYSTEM_HOSTTYPE: 'build'
2024-11-11T12:56:41.2893287Z ##[debug]SYSTEM_TEAMPROJECTID: 'a8ccafa3-555b-4836-a9a8-1bfeff553995'
2024-11-11T12:56:42.3421665Z ##[debug]Generated OIDC token.
2024-11-11T12:56:42.3756944Z ##[debug]Fetching Access Token - MSAL
2024-11-11T12:56:43.2404752Z ##[debug]Reaching SqlServer to check connection by running Invoke-SqlCmd
2024-11-11T12:56:43.2425215Z ##[debug]Run-InlineSql -authenticationType servicePrincipal -serverName *** -databaseName *** -sqlUserName  -sqlPassword  -sqlInline "select getdate()" -connectionString  -ErrorVariable errors -ConnectionTimeout 120 | Out-String
2024-11-11T12:56:43.2553486Z Temporary inline SQL file: C:\Users\VssAdministrator\AppData\Local\Temp\tmp8529.tmp
2024-11-11T12:56:43.2659717Z Invoke-Sqlcmd -AccessToken "**********" -ServerInstance "***" -Database "***"  -Inputfile "C:\Users\VssAdministrator\AppData\Local\Temp\tmp8529.tmp" 
2024-11-11T12:56:45.5764319Z ##[debug]Removing File C:\Users\VssAdministrator\AppData\Local\Temp\tmp8529.tmp
2024-11-11T12:56:46.8599359Z ##[debug]Agent environment resources - Disk: D:\ Available 12376.56 MB out of 14334.00 MB, Memory: Used 2119.00 MB out of 7167.00 MB, CPU: Usage 3.00%
2024-11-11T12:56:46.8601802Z ##[debug]Failed to reach SQL server ***. Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.
2024-11-11T12:56:46.8607496Z ##[debug]Error Message : System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.
2024-11-11T12:56:46.8608668Z ##[debug]   at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
2024-11-11T12:56:46.8610013Z ##[debug]   at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8611514Z ##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8612627Z ##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8613443Z ##[debug]Message To Parse: System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.
2024-11-11T12:56:46.8614590Z ##[debug]   at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
2024-11-11T12:56:46.8615221Z ##[debug]   at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8616286Z ##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8617230Z ##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
2024-11-11T12:56:46.8617736Z ##[debug]
2024-11-11T12:56:46.8618665Z ##[debug]Sql configured firewall wait time is invalid. So, setting it to defaul : 10
2024-11-11T12:56:46.8619290Z ##[debug]Sql firewall configured wait time : 10
2024-11-11T12:56:52.1602839Z ##[debug]Agent environment resources - Disk: D:\ Available 12376.56 MB out of 14334.00 MB, Memory: Used 2117.00 MB out of 7167.00 MB, CPU: Usage 3.00%
2024-11-11T12:56:55.2501944Z Temporary inline SQL file: C:\Users\VssAdministrator\AppData\Local\Temp\tmpB40A.tmp
2024-11-11T12:56:55.2515719Z Invoke-Sqlcmd -AccessToken "**********" -ServerInstance "***" -Database "***"  -Inputfile "C:\Users\VssAdministrator\AppData\Local\Temp\tmpB40A.tmp" -Encrypt Strict
2024-11-11T12:56:55.3714574Z ##[debug]Removing File C:\Users\VssAdministrator\AppData\Local\Temp\tmpB40A.tmp
2024-11-11T12:56:55.3760227Z ##[debug]No Firewall Rule was added
2024-11-11T12:56:55.3878575Z ##[debug]Caught exception from task script.
2024-11-11T12:56:55.3926350Z ##[debug]Error record:
2024-11-11T12:56:55.4494790Z ##[debug]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:56:55.4512594Z ##[debug]At D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\DeploySqlAzure.ps1:224 char:5
2024-11-11T12:56:55.4525712Z ##[debug]+     throw $errorMessage
2024-11-11T12:56:55.4538396Z ##[debug]+     ~~~~~~~~~~~~~~~~~~~
2024-11-11T12:56:55.4552631Z ##[debug]    + CategoryInfo          : OperationStopped: (Reason: Login f...roubleshooting-:String) [], RuntimeException
2024-11-11T12:56:55.4569297Z ##[debug]    + FullyQualifiedErrorId : Reason: Login failed due to client TLS version being less than minimal TLS version allow    ed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:56:55.4590670Z ##[debug] 
2024-11-11T12:56:55.4617926Z ##[debug]Script stack trace:
2024-11-11T12:56:55.4654444Z ##[debug]at , D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.247.0\DeploySqlAzure.ps1: line 224
2024-11-11T12:56:55.4668779Z ##[debug]at , : line 1
2024-11-11T12:56:55.4683572Z ##[debug]at , : line 22
2024-11-11T12:56:55.4699267Z ##[debug]at , : line 18
2024-11-11T12:56:55.4715802Z ##[debug]at , : line 1
2024-11-11T12:56:55.4740870Z ##[debug]Exception:
2024-11-11T12:56:55.5311266Z ##[debug]System.Management.Automation.RuntimeException: Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:56:55.5315214Z ##[error]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:56:55.5316452Z ##[debug]Processed: ##vso[task.logissue type=error]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
2024-11-11T12:56:55.5363236Z ##[debug]Processed: ##vso[task.complete result=Failed]
2024-11-11T12:56:55.5596724Z ##[section]Finishing: Setup initial SQL permissions

Repro steps

- task: SqlAzureDacpacDeployment@1
  displayName: 'Setup initial SQL permissions'
  condition: 
  inputs:
    azureSubscription: '${{ parameters.sqlServerAdminConnection }}'
    AuthenticationType: 'servicePrincipal'
    deployType: 'inlineSqlTask'
    serverName: '${{ parameters.sqlServerName }}'
    databaseName: '${{ parameters.sqlServerDatabaseName }}'
    InlineAdditionalArguments: '-Encrypt Strict'
    sqlInline: |   
      IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = '$(groupName)')
        BEGIN      
          CREATE USER [$(groupName)] FROM EXTERNAL PROVIDER
        END

      ALTER ROLE db_datareader ADD MEMBER [$(groupName)];