Sitecore Experience commerce installation error :The specified module ‘sqlps’ was not loaded because no valid module file was found in any module directory.

Install-SitecoreConfiguration : The specified module ‘sqlps’ was not loaded because no valid module file was found in
any module directory.
At C:\Program
Files\WindowsPowerShell\Modules\SitecoreInstallFramework\1.2.1\Public\Install-SitecoreConfiguration.ps1:253 char:21
+ & $entry.Task.Command @paramSet | Out-Default
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration

 

If you are getting this error then please have a look at C:\Program Files (x86)\Microsoft SQL Server folders to find  which version has following folder exist. In my case i’d it in 130\Tools\PowerShell\Modules\SQLPS

Next step is open powershell in admin mode and manually register it as below

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

and rerun the installation script !!!!

 

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s