Hi, I use SSMS... thks for OlafHelper-2800's idea!
You should right-click on your database then click "Start Powershell" and try your query in the newly opened SQL Server Powershell. It works for me. Hope this solves your problem.
Invoke-sqlcmd manual install , and invoke-sqlcmd still not reconized
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,351
Reputation points
I have manually install sqlserver powershell module .
https://www.powershellgallery.com/packages/Sqlserver/21.1.18245
and follow the below link steps
https://sqlserverunlimited.com/2019/08/01/powershell-install-sqlserver-module-offline/
after that I can see Sqlserver module are listed , however 'invoke-sqlcmd' still not reconized .
anything is missed. ? I have restart powershell, restart server but no luck.
and it's windows server 2016 and powershell module 5.1
and I am not able to use Install-Module command to install as there is no internet for the server .
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
-
-
Olaf Helper 47,616 Reputation points2021-05-14T05:46:16.697+00:00 I am not able to use Install-Module command to install as there is no internet for the server
And what do you now expect for the community?
-
sakuraime 2,351 Reputation points
2021-05-14T05:54:44.587+00:00 so which means manual install , there is problem .
who say powershell module must be install from internet ?
Sign in to comment
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 1%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CH2 1 Reputation point2022-10-17T02:12:07.423+00:00 -
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff2021-05-14T06:33:18.99+00:00 Hi @sakuraime ,
After the module has installed, the module commands including the Invoke-sqlcmd should be readily available. Please using below command to check if this module is listed.
Get-Command -ModuleName sqlserver-
sakuraime 2,351 Reputation points
2021-05-14T08:19:44.307+00:00 yes. it can get the command ..
however still said not reconized .
even in the Powershell ISE , I can see the module and the command in the right hand blade .
-
Olaf Helper 47,616 Reputation points
2021-05-14T08:51:05.827+00:00 Start SqlPs.exe instead of PS.exe.
-
sakuraime 2,351 Reputation points
2021-05-14T14:24:15.6+00:00 Hi @CathyJi-MSFT ... you have any idea ?
-
CathyJi-MSFT 22,426 Reputation points Microsoft External Staff
2021-05-17T03:03:12.49+00:00 Sorry for reply late. I will so some test and research , then share you the result.
Sign in to comment -
-
Olaf Helper 47,616 Reputation points
2021-05-14T06:29:56.447+00:00 Download th SQL Modul on a different machin and copy over the installer to server and install it.
See Install the SQL Server PowerShell module