Yes, RODBA can be unlocked on multiple machines using the same login information. Doing so will recreate the user in SQL with the same password.