Sample Header Ad - 728x90

powershell problem when running on a remote server - access is denied

2 votes
1 answer
1397 views
as a follow up from this question below: Run a PowerShell script on a different server - from inside a SQL Server job there you can see that for me tu run a powershell script from inside a sql server job, I need to create a proxy. Both the powershell script and the proxy script are on that link. what the powershell script does is to delete old backup files on a remote server. the question that I still have is: for the whole thing to work on windows server 2012, I could find not other way than granting Administrator on the remote box to the Proxy account. as you can see on the picture below. enter image description here another alternative was to create a powershell script that do both, backups and deletes, and create a sql server job with the following code: enter image description here Is this a powershell limitation when running on a remote server? Are there other ways to work around it, without having to grant admin to the proxy account? PowerShell Basics: Managing Remote Servers & Sessions
Asked by Marcello Miorelli (17274 rep)
Sep 16, 2015, 10:54 AM
Last activity: Jun 5, 2025, 04:05 PM