SQL executor add 'Application intent' parameter.
On a reader of sql non spatial you can set 'Application intent' to read only, but not on sql executor. So if your windows AUTH is set to read only you cant use sql executor on that database. This is very frustrating as its very difficult to fully automate my work flow.
