This issue can occur when using when you are using a SQL Change Automation Azure DevOps add-on, using an older task version, and the self-hosted agent you are using cannot download the SQL Change Automation Powershell module from the Powershell Gallery.
This was caused by a recent change in the Powershell Gallery TLS Support: https://devblogs.microsoft.com/powershell/powershell-gallery-tls-support/
Change task version number to 4.x (which connects using TLS 1.2)
0
0
Was this article helpful?
0 out of 0 found this helpful
Articles in this section
- Method not found: 'System.Security.CodeAccessPermission
- Couldn't connect to the database specified by the Target parameter: A connection was successfully established with the server, but then an error occurred during the login process
- Could not install SqlChangeAutomation from any registered PSRepository
- System.Exception: No match was found for the specified search criteria and module name 'SQLChangeAutomation'. Try Get-PSRepository to see all available registered module repositories
- No match was found for the specified search criteria and module name 'SqlChangeAutomation'.
- Online index operations can only be performed in Enterprise edition of SQL Server
- Unable to resolve package source
- error 5(Access is denied.) while attempting to open or create the physical file
- SQL Change Automation Installation freezes at 99%
- SQL Change Automation Powershell permissions