Our sys admin created user service accounts for each user.

So you mean I should be able to use File dsn instead of system dsn? I think File dsn is fine too. But only demand is we should use otherdomain\serviceaccount to connect to sql server.