I'm trying to execute a powershell script, and use a proxy to do. The job runs correctly, but using
whoami within the script to log the executing user indicates that the script is not being run by the user I (think I) specified in the proxy.
I have a credential, with the correct username and password for the windows server:
I have a proxy set up to use that credential:
Is specified as a principle for this proxy
Has its own login
Is the job owner
I'm using the proxy to
Run As in the job step:
However, as mentioned, logging within the script indicates that
[Domain]\MSSQLService02 is the user executing the script.
I don't know if I'm misunderstanding the use of proxies, I'm missing a step, or something is misconfigured.