Dear all,
I have some questions regard subject above. I want to know the impact of replication process after SA pasword been changed.
Example: server1 (hq), server2 (district) & server3 (district).
If server1, SA password been changed, is it server2 & server3 need to change too?
may i know where is it the replication SA password stored? is it replication script refer ID (SA) from Security -> Logins?
I hope someone can help me.. thanks.
changing the Sa password would not harm the replication process
ideally...
replication is using the account used by the sqlserver agent services.
to know what account is your agent services running.
click start>run>type "services.msc">look for sqlserver agent
Click on Log On> this is the account used by replication.
usually this is a domain account..
if your system is configure in this manner, then changing the "Sa" password
will not matter at all.
If it configured some other way around then you have to watch out for the account
being used in the replication
No comments:
Post a Comment