Need help trying to allow my remote PowerShell script to run on my Windows 2008 r2 Server
        Posted  
        
            by 
                Pure.Krome
            
        on Server Fault
        
        See other posts from Server Fault
        
            or by Pure.Krome
        
        
        
        Published on 2011-04-28T02:36:23Z
        Indexed on 
            2012/03/25
            23:32 UTC
        
        
        Read the original article
        Hit count: 286
        
I've got a Windows 2008 r2 server with Sql Server 2008 r2 installed. I've got a Sql Server Agent which tries to run a Powershell job, but fails :-
Message
Executed as user: FooServer\SqlServerUser. 
A job step received an error at line 1 in a PowerShell script. 
The corresponding line is '& '\\polanski\Backups\Database\7ZipFooDatabases.ps1'' 
Correct the script and reschedule the job. The error information returned
    by PowerShell is: 'File \\polanski\Backups\Database\7ZipFooDatabases.ps1
    cannot be loaded.
The file \\polanski\Backups\Database\7ZipFooDatabases.ps1 is 
    not digitally signed.
The script will not execute on the system.
Please see "get-help about_signing" for more details..  '.
Process Exit Code -1.  
The step failed.
Ok. So i run Powershell on that server then set the execution policy to unrestricted. To check ..
PS C:\Users\theUser> Get-ExecutionPolicy
Unrestricted
PS C:\Users\theUser>
Kewl :) but it still doesn't work :(
Ok ... what happens when i try to run the powershell from the command line....
PS C:\Users\justin.adler> . '\polanski\Backups\Database\7ZipMotorshoutDatabases.ps1'
Security Warning
Run only scripts that you trust. While scripts from the Internet can be useful,
    this script can potentially harm your computer.
Do you want to run \\polanski\Backups\Database\7ZipFooDatabases.ps1?
[D] Do not run  [R] Run once  [S] Suspend  [?] Help (default is "D"): 
er..... didn't I already tell the server that ANY file can be ran?
Notice the file is located at...
\\polanski\Backups\Database\
So can someone make any suggestions?
© Server Fault or respective owner