title: Use SSIS to launch powershell script that remotely launches a batch file without Administrator rights
body: <p>We have a SQL server (Name: SQL) that launches an SSIS job with proxy credentials (a service account), consisting of multiple steps.  </p>
  
  <p>One of these steps require files to be put in a local folder on a remote machine (Name: VM) and execute a program that securely copies these files to a service on the net.  I have successfully ran both PowerShell and WinRM commands to do this (as administrator), but I need to find a way to run them without being an admin on SQL.</p>
  
  <p>All of these steps work fine, when the service account is a local administrator of both SQL and VM.  However, we do not want the service account to be a local admin on SQL.</p>
  
  <p>The command I run is:<br>
  Invoke-Command -ComputerName vm.fqdn -ScriptBlock {E:\Share\ThirdParty\FTP_Admin\FtpUpload.bat}</p>
  
  <p>I found a google post suggesting I need to give access to the root/CIIV2 namespace.  I gave the service account full control and restarted the WinRM service.  </p>
  
  <p>When it fails (NOT running as administrator), the security log gets populated with 4656 event ID's.</p>
  
  <p>Any idea what I can try?  Been stumped on this for a while.</p>