Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maillisting
Starting Member
5 Posts |
 Posted - 2009-03-19 : 04:49:09
|
| HI, I have a merge replication using sa between 2 servers (publisher A & subscriber B). Recently, I change the password of sa in security.logins.sa in both servers. After that the replication failed. Publisher A keeps to report the following error. Anyone can tell me what is the proper way to change the password of sa without affect the existing replication?The process could not connect to Subscriber 'B'.(Source: B (Agent); Error number: 20084)---------------------------------------------------------------------------------------------------------------Login failed for user 'sa'.(Source: B (Data source); Error number: 18456)---------------------------------------------------------------------------------------------------------------thanks, ango |
|
|
|
|
|
change password on existing replication