Just a thought (I am still learning with Powershell and SQL).

When you run the script in the ISE, are you logged into Windows using an account that is also an SQL Administrator?

It may be the mixed mode authentication is failing but the Windows authentication still allows the script to run.

When you then run this as the agent, it can't use the Windows authentication.

Then again I may be completely wrong.