David Webb-200187 (9/11/2012)
Are you using windows authentication (probably won't work if the workstations aren't authenticating to a domain with a trusted relationship to the server) or SQL authentication?
Honestly, I don't even see SQL authentication working unless he can build a dedicated connection between the workstations.
And notice that he did say workstations, not servers. So with two workstations not in the same building, and connecting to the internet on 2 different ISPs, we've potentially got a lot more problems here than just the basic security one.