PowerShell 4 - Import-Module : The specified module 'SQLPS' was not loaded because no valid module file was found in any module directory

powershell import-module sqlps
Yogesh Patel picture Yogesh Patel · Oct 30, 2015 · Viewed 53.6k times · Source

Previously working with PowerShell 3. Upgraded to PowerShell 4 and uninstalled it as facing error stated. Import-Module : The specified module 'SQLPS' was not loaded because no valid module file was found in any module directory. But all SQL related stuff is working fine without the error. What is the root cause of this error in PowerShell console?

Answer

RiverHeart picture RiverHeart · Mar 27, 2016

Sounds like you need to manually update the module path.

Check to see that this directory exists on the computer.

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\SQLPS

[Fixed]

If it does then run

$env:PSModulePath = $env:PSModulePath + ";C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules"

Then check to see if the SQLPS module is in the list of available modules using

get-module -listavailable

Related questions

Powershell Invoke-SQLCmd and SQLPS

Windows 7 workstation POSH 3.0 SS 2012 SP1 Abstract: Developer 1 cannot run Invoke-SQLCmd Developer 2 with similar SS Client tools installation can run Invoke-SQLCmd Developer 1 cannot run Import-Module SQLPS When I try to run a query from my laptop like the following: Invoke-sqlcmd -ServerInstance &…

Read More
What's the difference between Add-PsSnapIn and Import-Module

Powershell has two means for importing additional cmdlets into a session, Add-PsSnapIn and Import-Module. The docs are not at all clear regarding when one would chose one over the other. Does anybody know the difference between these?

Read More
Editing an already imported module

Before importing my powershell module (MyModule.psm1), I have written one function in it: Function T1() { Write-Host "T1 is just called" -ForegroundColor red } In my MyModule.psd1: @{ PowerShellVersion = '2.0' PowerShellHostName = '' PowerShellHostVersion = '2.0' RequiredModules = @() ScriptsToProcess = @() NestedModules = @() FunctionsToExport = '*…

Read More