When I try to run a powershell script I get the following error:
Invoke-SqlCmd Command cannot be found on this machine, please install the SQL Powershell tools
So in Powershell I run the following:
install-module sqlserver
update-module sqlserver
Both run fine. However when I rerun my script I still get the same error.
Any ideas on what I should try?
I have SQLServer 2014 and Powershell Version 5