We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Problem with PowerShell SQL Server Modules
Posted on 2016-10-27
I am blue in the face and EXTREMELY frustrated. I have spent two days trying to implement sqlps SQL Server extensions on one of our server. I have followed the instructions at http://guidestomicrosoft.com/2015/01/13/install-sql-server-powershell-module-sqlps/. I have checked dozens of websites and am not having any luck. When I try to execute import-module sqls I get the 'standard' error message:
"import-module : The specified module 'sqlps' was not loaded because no valid module file was found in any module directory."
There has to be something strange in my environment because I have checked everything that I've come across on the internet that it is suggested I check. Any help in resolving this would be greatly appreciated.
This is a production SQL Server environment running Windows Server 2008 R2 Standard, SP1 (64-bit) and SQL Server 2012 SP1 (also 64-bit).
"import-module : The specified module 'sqlps' was not loaded because no valid module file was found in any module directory."
There has to be something strange in my environment because I have checked everything that I've come across on the internet that it is suggested I check. Any help in resolving this would be greatly appreciated.
This is a production SQL Server environment running Windows Server 2008 R2 Standard, SP1 (64-bit) and SQL Server 2012 SP1 (also 64-bit).
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
9 Comments
Active today
Where is the modul file located in fact? You can always provide the full path to make sure it is found.
C:\Program Files\Microsoft SQL Server\110\Tools\PowerShel
$env:PSModulePath has that location in the path.
$env:PSModulePath has that location in the path.
Active today
A wrong path in PSModulePath can stop PS from searching. Try by directly providing the path when importing
import-module 'C:\Program Files\Microsoft SQL Server\110\Tools\PowerShell\Modules\SQLPS\sqlps.psd1' -verbose
well, I have to admit that this is both joyous and perplexing. Joyous because it works. Perplexing because all the directories in the path are valid. The 'bad' part of it is that I am going to have to put in a switch statement because some of our servers have SQL Server installed on the D drive and some on the C drive (don't ask why).
Yes it was a typo in the question, verified by the error message, which I cut-and-pasted ("The specified module 'sqlps' was not loaded..." )
Just out of curiosity, I edited the PSModulePath environment variable to have just the one path (C:\Program Files\Microsoft SQL Server\110\Tools\PowerShel
Featured Post
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article we will learn how to fix “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 18 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.