Powershell SqlPs module not importing properly

Question

I have a (pretty much clean) Windows Server 2008 R2 Build with SQL Server 2012 installed. I'm having a problem with PowerShell (Version 3).

I am trying to use the Invoke-Sqlcmd cmdlet. However, when I call get it i get a message saying that 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program.

It works if if I run Import-Module SqlPs -Verbose -Force (bypassing the security policy). However it this lasts only as long as the tab is open. If i open a new tab, try to run another script or re-open Powershell ISE I have to import the module all over again.

Any ideas why this is happening?

Check your $PSModuleAutoLoadingPreference variable: about_Modules. — beatcracker
– beatcracker, Commented Feb 19, 2016 at 10:27

tajen · Accepted Answer · 2016-02-19 18:57:36Z

1

This is more of a work around, but you can add it to your profile.

"'Import-Module SqlPs -Verbose -Force'" > $profile

Obviously if you have a profile file from before, you dont want to do it like that, but instead open it and add it through notepad or similar.

Also note that Powershell and PowershellISE has different profiles, so you would need to add it in both if you mix.

answered Feb 19, 2016 at 18:57

tajen

1757 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben Thul · Accepted Answer · 2016-02-19 16:54:38Z

0

From my understanding, module loading is done on a per session basis. So the behavior you're seeing is what is expect.

answered Feb 19, 2016 at 16:54

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

Powershell SqlPs module not importing properly

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related