powershell - Exe file remote Execution -
i'm trying write script patch sql instances remotely. referring forum, have framed following line executing .exe remotely on other server:
invoke-command -computername $computer -scriptblock { & cmd /c 'd:\sql_patch\sqlserver2012sp2-kb2958429-x64-enu.exe' /qs /action=patch /allinstances /iacceptsqlserverlicenseterms }
also tried well:
invoke-command -computername $computer -scriptblock { & 'd:\sql_patch\sqlserver2012sp2-kb2958429-x64-enu.exe' -argumentlist "/qs", "/action=patch", "/allinstances", "/iacceptsqlserverlicenseterms" }
one more peculiar thing is, first command running fine on windows 2012 servers not on windows 2008r2 server. don't know what's reason behind this.
the following did trick looking for:
psexec \\$computer -s -u adminuser -p adminpassword e:\sql_patch\sqlserver2012sp2-kb2958429-x64-enu.exe /quiet /action=patch /allinstances /iacceptsqlserverlicenseterms
this piece working on servers irrespective windows versions. valuable suggestions.
Comments
Post a Comment