Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP!! "Login failed for user 'sa'" when trying connect to subscriber

Status
Not open for further replies.
Miriam

Miriam

Programmer
Sep 27, 2000
19
0
0
US
Hello,

I have merge replication set up to push a table out to subscribers on the same server. The SA password was changed and now the distribution agent for the subscriber cannot connect.
I'm getting an error: "Login failed for user 'sa'"

Where I can change this password in the replication properties? Do I have to drop the subscription and recreating it? Do I need to drop the entire publication and start over?

Thank you in advance,
Miriam
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
746
gmmastros
gmmastros
f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
88
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
226
Chris Miller
Chris Miller
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
274
Chris Miller
Chris Miller
V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
205
Volvere
V

Part and Inventory Search

Sponsor

Back
Top