RE: GP Error Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
It isn't an error we see frequently, and with so many third party products in place, it's hard to say really short of ruling them out to determine which is causing the error.
That being said, from what I could find that would cause this type of message are:
>>Firewall blocking ports that Active Directory and SQL Server use to communicate.
>>For eConnect for Dynamics GP, I know the service account running the eConnect service(s) should be a domain user account if eConnect is on a different server than the SQL Server, it also needs to be assigned the DYNGRP role for all GP databases. I've also seen a couple forums mention adding this account as a local administrator and restarting the eConnect service(s), to test connection type issues as this.
If the error is coming when attempting to use a third party product such as Datamill that you mentioned, or another, you may be best served to keep trying to contact them, and then hopefully others in this forum community may have experience with these products/add-ins as well and can give additional information.
Thanks