search

DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
20 stars 14 forks source link

[BUG] newly upgrade OnPrev DevOps 2022.0.1 fails #48

Closed DuckoDeath closed 1 year ago

DuckoDeath commented 1 year ago

AzureDevOpsServer_20230418.1 Been using this extension for a long time, just upgraded DevOps, now fails with:

The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

any help would be appreciated

DrJohnT commented 1 year ago

Will depend on your build agent. An in-house agent will require Powershell SqlServer module installing: https://www.powershellgallery.com/packages/SqlServer

Be sure to uninstall SqlPs (see https://github.com/DrJohnT/AzureDevOpsExtensionsForSqlServer/wiki/Build-Server-Setup#delete-the-microsoft-sql-server-powershell-environment-variable )

For Microsoft Agents in the cloud, not sure they will be able to contact your on-prem servers to perform the install

DuckoDeath commented 1 year ago

For the record, had to uninstall the existing SqlServer powertools, and reinstall the latest version....