Get-ItemProperty:找不到path'HKLM:\ SOFTWARE \ Microsoft \ PowerShell \ 1 \ ShellIds \ Microsoft.SqlServer.Management.PowerShell.sqlps'

我已经尝试重新安装SQL Server 2014,并且在尝试import-module sqlps时仍然收到以下错误消息。 存在相同的registry项,但附加了120.我可以使用像Invoke-SqlCmd这样的命令。 不知道这是什么问题。 任何帮助赞赏。

  • 操作系统:Windows 7企业版本6.1 Build 7601:Service Pack 1。
  • SQL Server:SQL Server 2014开发版。

在x86窗口中:

 PS H:> import-module sqlps -disablenamechecking Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps' because it does not exist. At C:\Users\russell_johnson\Documents\WindowsPowerShell\Modules\sqlps\sqlps.psm1:26 char:13 + $item = Get-ItemProperty $sqlpsreg + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (HKLM:\SOFTWARE...owerShell.sqlps:String) [Get-ItemProperty], ItemNotFoundException + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.GetItemPropertyCommand 

在x64窗口中:

 PS H:\> import-module sqlps Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps' because it does not exist. At C:\Users\russell_johnson\Documents\WindowsPowerShell\Modules\sqlps\sqlps.psm1:26 char:13 + $item = Get-ItemProperty $sqlpsreg + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound : (HKLM:\SOFTWARE\...owerShell.sqlps:String) [Get-ItemProperty], ItemNotFoundException + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.GetItemPropertyCommand WARNING: The names of some imported commands from the module 'sqlps' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb. PS SQLSERVER:\> 

如果将$ sqlpsreg更改为HKLM \ Software \ Wow6432Node \ Microsoft \ PowerShell \ 1 \ ShellIds \ Microsoft.SqlServer.Management.PowerShell.sql,它是否正常工作

运行SQL 2014更新脚本HKLM:\ SOFTWARE \ Microsoft \ PowerShell \ 1 \ ShellIds \ Microsoft.SqlServer.Management.PowerShell.sqlps120

按预期运行