SQL replication is a real pain to get working, there are many, many things that can go wrong ...
Have a look though
the following[
^]
It's much easier to have a domain login (with non-expiring password) that the two servers use for logins and sharing REPL data with