locked
Powershell: Import-Module "sqlps" fails RRS feed

  • Question

  • Hi, 

    The Import-Module "sqlps" fails for my Powershell:

    PS D:> Import-Module SQLPS
    Import-Module : The specified module 'SQLPS' was not loaded because no valid module file was found in any module
    directory.
    At line:1 char:1
    + Import-Module SQLPS
    

    I have SSMS 2008R2 installed on a Win7. I believe I have the SQL Server 2008 R2 client components, because I can start the sqlps utility by inputting “sqlps.exe” on Search programs and files text when click Start menu, and get this:

    Microsoft SQL Server PowerShell
    Version 10.50.1600.1
    Microsoft Corp. All rights reserved.
    
    PS SQLSERVER:\>
    

    Any other pieces I'm missing?

    Thanks

    Tuesday, May 7, 2013 4:25 PM

Answers