Runbooks执行PowerShell脚本报错求助：Invoke-ASCmd未识别

问题概述 #

在Runbooks中执行PowerShell脚本时遇到Invoke-ASCmd未被识别的错误，但本地执行完全正常。尝试安装包含该命令的SqlServer模块时，又接连遇到NuGet版本不足、NuGet安装失败的问题。

核心错误：Invoke-ASCmd未识别 #

Invoke-ASCmd : The term 'Invoke-ASCmd' 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.
At line:27 char:1
+ Invoke-ASCmd -Query $TmslScript -Server: $XmlaEndpoint -Database $Dat ...
+ ~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Invoke-ASCmd:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

安装SqlServer模块时的错误 #

执行安装命令：

Install-Module SqlServer -RequiredVersion 21.1.18230 -Scope CurrentUser -SkipPublisherCheck -AllowClobber -Force

出现两类错误：

1. 交互请求失败（Runbooks环境不支持用户交互）：

Exception calling "ShouldContinue" with "2" argument(s): "A command that prompts the user failed because the host program or the command type does not support user interaction. The host was attempting to request confirmation with the following message: PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet provider must be available in 'C:\Program Files\PackageManagement\ProviderAssemblies' or 'C:\Users\Client\AppData\Roaming\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running 'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and import the NuGet provider now?"
At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7455 char:8
+ if($Force -or $psCmdlet.ShouldContinue($shouldContinueQueryMessag ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : HostException

2. NuGet版本不符合要求：

Install-Module : NuGet provider is required to interact with NuGet-based repositories. Please ensure that '2.8.5.201' or newer version of NuGet provider is installed.
At line:12 char:1
+ Install-Module SqlServer -RequiredVersion 21.1.18230 -Scope CurrentUs ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Install-Module], InvalidOperationException
+ FullyQualifiedErrorId : CouldNotInstallNuGetProvider,Install-Module

安装NuGet时的错误 #

执行NuGet安装命令：

Install-PackageProvider -Name NuGet -Scope CurrentUser -Force

报错：

Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'. The package provider requires 'PackageManagement' and 'Provider' tags. Please check if the specified package has the tags.
At line:11 char:1
+ Install-PackageProvider -Name NuGet -Scope CurrentUser -Force
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (Microsoft.Power...PackageProvider:InstallPackageProvider) [Install-PackageProvider], Exception
+ FullyQualifiedErrorId : NoMatchFoundForProvider,Microsoft.PowerShell.PackageManagement.Cmdlets.InstallPackageProvider

解决方案 #

1. 先修复NuGet安装问题 #

Runbooks环境默认的PowerShellGet版本可能偏低，需先更新PowerShellGet再安装NuGet：

# 信任PSGallery仓库
Set-PSRepository -Name PSGallery -InstallationPolicy Trusted

# 更新PowerShellGet模块
Install-Module -Name PowerShellGet -Force -AllowClobber -Scope CurrentUser

# 重新加载PowerShellGet
Import-Module PowerShellGet -Force

# 安装指定最低版本的NuGet提供器，跳过交互
Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force -Scope CurrentUser

2. 安装SqlServer模块 #

NuGet安装完成后，执行以下命令安装指定版本的SqlServer模块：

Install-Module SqlServer -RequiredVersion 21.1.18230 -Scope CurrentUser -SkipPublisherCheck -AllowClobber -Force

3. 确保模块正确加载 #

在调用Invoke-ASCmd前，显式导入SqlServer模块：

Import-Module SqlServer -RequiredVersion 21.1.18230 -Force

4. 完整Runbooks脚本示例 #

将所有步骤整合，确保顺序执行：

# 配置PSGallery信任
Set-PSRepository -Name PSGallery -InstallationPolicy Trusted

# 更新PowerShellGet
Install-Module -Name PowerShellGet -Force -AllowClobber -Scope CurrentUser
Import-Module PowerShellGet -Force

# 安装NuGet提供器
Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force -Scope CurrentUser

# 安装SqlServer模块
Install-Module SqlServer -RequiredVersion 21.1.18230 -Scope CurrentUser -SkipPublisherCheck -AllowClobber -Force

# 导入SqlServer模块
Import-Module SqlServer -RequiredVersion 21.1.18230 -Force

# 执行目标命令
Invoke-ASCmd -Query $TmslScript -Server $XmlaEndpoint -Database $DatasetName

额外注意事项 #

• 确保Runbooks执行账号拥有对应目录的读写权限（使用Scope CurrentUser时，需对用户目录有操作权限）
• 若使用Azure Automation Runbooks，可直接在自动化账户中通过门户导入SqlServer模块，避免每次执行脚本重复安装，提升执行效率

内容的提问来源于stack exchange，提问作者Joel G