Support for Azure DevOps 2020

[mosheytiko]

Hi team,
are you planning to release 2020 version?

[gprosch]

It's been a few years and still nothing for the 2020 version. An update would be very much appreciated.

[cvocvo]

+1 for 2022 now

[TMattes]

We also would appreciate an update on this, although scripts of ADO 2019 are still usable on ADO 2022.
But: why aren't these scripts digitally signed? We always have to work around this circumstance...

[xfiles-92]

Is there any news on the ADO 2022 version of the scripts being released ???

[bballpaul4work]

How do you work around the fact that they're not digitally signed? I get the error "The certificate chain was
issued by an authority that is not trusted" when trying to run Invoke-SqlCmd for ADO 2022

[xfiles-92]

I have literally just added this switch -TrustServerCertificate to every Invoke-Sqlcmd in the scripts to get around the certificate issues.

$queryResults = Invoke-Sqlcmd -InputFile "$PWD\SqlScripts\CodeAccountFaultInResult.sql" -serverInstance $SQLServerInstance -database $ConfigurationDatabaseName -Verbose -Variable $Params -TrustServerCertificate

This has allowed me to run most of the PowerShell scripts against DevOps 2022

[bballpaul4work]

Ha brilliant! This has worked for me as well

[kohithms]

Hi @steved0x,

Any update on the scripts for 2020 server ?