Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1141
  • Last Modified:

Problem with PowerShell SQL Server Modules

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
dbbishop
Asked:
dbbishop
  • 5
  • 4
1 Solution
 
QlemoC++ DeveloperCommented:
Where is the modul file located in fact? You can always provide the full path to make sure it is found.
0
 
dbbishopAuthor Commented:
C:\Program Files\Microsoft SQL Server\110\Tools\PowerShell\Modules\SQLPS\
$env:PSModulePath has that location in the path.
0
 
QlemoC++ DeveloperCommented:
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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
dbbishopAuthor Commented:
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
 
QlemoC++ DeveloperCommented:
You wrote import-module sqls - is that a typo in the question?
0
 
dbbishopAuthor Commented:
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
 
QlemoC++ DeveloperCommented:
Using bold and stuff helps to make that obvious :p.
0
 
dbbishopAuthor Commented:
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
 
QlemoC++ DeveloperCommented:
Test with Get-Module -ListAvailable and the original env var if there are modules found at all.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now