错误信息如下:
'File C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\SQLPS\Sqlps.ps1 cannot be loaded because running scripts is disabled on this system
根据错误信息提示检查发现服务器注册表里缺少内容-Microsoft.SqlServer.Management.PowerShell.sqlps130键值对信息
应该是这样的,
更新注册表即可。把下面代码块里的内容粘贴到文本编辑器里,修改后缀为.reg,然后鼠标左键双击执行。
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps130] "Path"="C:\\Program Files (x86)\\Microsoft SQL Server\\130\\Tools\\Binn\\SQLPS.exe" "ExecutionPolicy"="RemoteSigned"
参考文档 https://blog.pythian.com/powershell-error-sqlps-ps1-cannot-loaded-running-scripts-disabled-system/
标签:disabled,syspolicy,scripts,SqlServer,Microsoft,purge,failed,注册表,PowerShell From: https://www.cnblogs.com/dxmdiy/p/17361565.html