Jord, I had a similar issue. It worked fine local, but failed when I moved the db to AWS. I found that my connection string had "Integrated Security=True" set. Once I changed it to false, everything lit up fine.
Also, another name for it is "Trusted Security", so that should be 'False" too.
Here is what Microsoft says:
Integrated Security -or- Trusted_Connection 'false' When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication. Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.