Mirrored local accounts to connect to database on different server and domain
That is not a sql server question but a windows question.
If you have multiple computers, login on one with a local account and try to connect to another computer it will try to use the username and check it against its own local account database. If the passwords match the challenge/respone authentication will succeed.
As far as I remember the users have to be local accounts - on both sides.