Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem with PowerShell SQL Server Modules

Posted on 2016-10-27
9
Medium Priority
?
931 Views
Last Modified: 2016-10-28
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).
0
Comment
Question by:dbbishop
  • 5
  • 4
9 Comments
 
LVL 71

Expert Comment

by:Qlemo
ID: 41862488
Where is the modul file located in fact? You can always provide the full path to make sure it is found.
0
 
LVL 15

Author Comment

by:dbbishop
ID: 41862580
C:\Program Files\Microsoft SQL Server\110\Tools\PowerShell\Modules\SQLPS\
$env:PSModulePath has that location in the path.
0
 
LVL 71

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 41862765
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

Open in new window

0
WatchGuard Case Study: NCR

With business operations for thousands of customers largely depending on the internal systems they support, NCR can’t afford to waste time or money on security products that are anything less than exceptional. That’s why they chose WatchGuard.

 
LVL 15

Author Comment

by:dbbishop
ID: 41862812
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).
0
 
LVL 71

Expert Comment

by:Qlemo
ID: 41862826
You wrote import-module sqls - is that a typo in the question?
0
 
LVL 15

Author Comment

by:dbbishop
ID: 41862830
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..." )
0
 
LVL 71

Expert Comment

by:Qlemo
ID: 41862858
Using bold and stuff helps to make that obvious :p.
0
 
LVL 15

Author Comment

by:dbbishop
ID: 41863805
Just out of curiosity, I edited the PSModulePath environment variable to have just the one path (C:\Program Files\Microsoft SQL Server\110\Tools\PowerShell\Modules\SQLPS) and still get the error, so not sure what the "underlying" problem is.
0
 
LVL 71

Expert Comment

by:Qlemo
ID: 41863853
Test with Get-Module -ListAvailable and the original env var if there are modules found at all.
0

Featured Post

Technology Partners: We Want Your Opinion!

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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question