SQL Powershell Error: Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet

Question

When I try to run a powershell script I get the following error:

Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program.

So in Powershell I ran the following:

install-module sqlserver
update-module sqlserver
import-module sqlserver

This all runs fine. However when I rerun my script I still get the same error.

I have also installed powershelltools.msi, downloaded as part of the SQL Server 2014 Feature pack here: https://www.microsoft.com/en-gb/download/details.aspx?id=42295

If I run this command:

Get-Command -Module sqlserver

I get this result:

CommandType     Name                                               Version    Source
-----------     ----                                               -------    ------
Alias           Decode-SqlName                                     21.0.17224 sqlserver
Alias           Encode-SqlName                                     21.0.17224 sqlserver
Function        SQLSERVER:                                         21.0.17224 sqlserver

Any ideas on what else I should try?

I have SQLServer 2014 and Powershell Version 5

Throw in the code that you are using, it could be something to do with that e.g. Remote querying, etc — Shaneis
– Shaneis, Commented Feb 5, 2018 at 12:56
If I do 'Import-module sqlserver', then 'Invoke-Sqlcmd' immediately after that in the same session, I get the same error. 'Get-Command -Module sqlserver' returns a list of 2 aliases 'Decode-sqlName', and 'Encode-sqlName', and a function 'SQLSERVER:' — PRS
– PRS, Commented Feb 5, 2018 at 13:30
Those lines match the first 3 lines here but then all the CmdLet's are listed, — crokusek
– crokusek, Commented Oct 17, 2018 at 22:04

Rick · Accepted Answer · 2019-03-01 22:45:53Z

2

Are you using Powershell Core (v6.1)?

I was having a similar issue and found this SO answer. Turns out the SQLServer module for Powershell Core doesn't include the Invoke-SqlCmd (among others). I switched back to the 64-bit version of Powershell I have installed on Windows 10 (v5.1) and installed, then imported the sqlserver module. Invoke-SQLCmd is now listed.

Install-Module -Name SqlServer -AllowClobber
Import-Module -Name SqlServer -Force
Get-Command -Module SqlServer

answered Mar 1, 2019 at 22:45

Rick

5,0293 gold badges35 silver badges35 bronze badges

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

2 Comments

Randy in Marin Over a year ago

FYI For those with 7.2 having this issue, I used just the install-module. I was unable to use invoke-sqlcmd until after I restarted VSCODE.

Trisped Over a year ago

PowerShell Core now has the Invoke-Sqlcmd command according to this SO answer.

Petr Snizek · Accepted Answer · 2018-02-05 13:16:12Z

0

Import-Module imports a module only to current powershell session, not globally. Add the import to your script or to profile.

answered Feb 5, 2018 at 13:16

Petr Snizek

266 bronze badges

2 Comments

PRS Over a year ago

If I do 'Import-module sqlserver', then 'Invoke-Sqlcmd' after that in the same session, I get the same error.

Dicky Moore Over a year ago

Try Import-Module SQLPS

siddharth · Accepted Answer · 2019-04-24 20:38:23Z

0

Was searching a solution for the same problem and found the below worked for me.

find-module sqlserver | Install-Module -AllowClobber -Force

Original Answer: https://social.technet.microsoft.com/Forums/en-US/f3a52235-e62a-402e-9b1b-0b0c0cdd17aa/sql-powershell-error-invokesqlcmd-the-term-invokesqlcmd-is-not-recognized-as-the-name-of-a?forum=winserverpowershell

answered Apr 24, 2019 at 20:38

siddharth

6862 gold badges7 silver badges19 bronze badges

Comments

Machavity · Accepted Answer · 2019-08-22 12:22:43Z

0

I had the same problem. Apparently I had to unblock all the dll files in the new module folder. In my case C:\Program Files\WindowsPowerShell\Modules\SqlServer. I found the link here how to do it. https://www.404techsupport.com/2016/06/24/unblock-files-powershell/

dir -Path [directory path] -Recurse | Unblock-File

Close powershell if you still have a session open.

edited Aug 22, 2019 at 12:22

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

answered Aug 22, 2019 at 11:59

user_SS

411 bronze badge

Collectives™ on Stack Overflow

SQL Powershell Error: Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related