HI, can somebody confirm if Powershell plugin can work using remoting in a 
Jenkins job?

I have a win 2012 box where Jenkins reside and Powershell works fine when 
executing commands on the machine itself.

I need to do powershell remotely to another win 2012 and issue commands 
from SQL server Powershell provider, in ISE or powershell command prompt, I 
run the following 

$password = ConvertTo-SecureString "password" -AsPlainText -Force
$cred= New-Object System.Management.Automation.PSCredential ("domain\user", 
$password )
Enter-PSSession -ComputerName SQL2K12 -Credential $cred
get-command invoke-sqlcmd


I get 

> invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of 
> a cmdlet, function, script file, or operable 
> program. Check the spelling of the name, or if a path was included, verify 
> that the path is correct and try again.
> At C:\Users\salam\AppData\Local\Temp\hudson2013311959155688202.ps1:8 char:1
> + invoke-sqlcmd -query "sp_databases" -database master 


So I did a very basic test to see whther Jenkins powershell is really 
establishing a remote connection and changed the "invoke-sqlcmd ......" by 
"ls"

Job worked and in Jenkin's console output, I saw that it has listed the 
contents of the workspace.

Thanks for your help and confirmation
N.B : I have already posted 3 hours ago in this forum about the same issue, 
but I think that the test that I have just done has proved something to me 
and wanted to share with you

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/e8e3fe18-58de-4536-a062-8728d8365533%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to