Hi guys, I'm a bit of a noob on SQL so please excuse any dumb questions. I have a merge replication setup with a global server (publisher) and 2 regional servers (subscribers). It is running fine with the default sa password. As soon as I change the sa password on any of the regional servers it fails the replcation with the fault of "Login failed for user sa". I have changed the sa password on one of the regional servers using Mangement Studio. I also used the update replication passwords on the regional server under replication. Then I also change the password on the publisher by right clicking the subscriber and going to properties and changing the subsciber connection password for sa. It still fails and will work the moment I change the sa password back to default in all areas. Have I missed something here??
Thanks in advance.