Thursday, February 16, 2012

can Password change affecting replication

Hi all,
Wew have a need to change the sa password of all our servers. How can change
in the sa password affect the replication.
RegarDs,
JerriN
It all depends It will have an impact if you are using SQL authentication
for any of the agents. If it is a typical setup, the replication agents will
run under the impersonation of the SQL Server agent's login, which is
typically the same login that SQL Server itself uses, so there should be no
impact at all.
HTH,
Paul Ibison

No comments:

Post a Comment