Powershell in SQL Agent Step Insufficient Permissions
I'm trying to update Active Directory from a PowerShell script step in an SQLServer Agent Step.(selected PowerShell for step type) The service account SQLServer Agent runs under has permissions to update AD (Domain Admin) If I log in as the SQLServer Agent account i can run the script successfully. When it runs as a scheduled job, it fails with insufficient permissions error. Any idea how i can get this to run with the proper elevated permissions from within the SQL job?