GaryPhillips
SSC Enthusiast
Points: 143
More actions
June 14, 2002 at 8:57 am
#78824
Can anybody tell me if replication is affected when you change the sa password.
Will my publications/subscriptions still work or do I have to recreate them ?
Andy Warren
SSC Guru
Points: 119902
June 14, 2002 at 11:02 am
#430905
If you're using the SA account to connect to distributor or subscriber you'll have to change them. Need to check both logreader and distribution agent jobs, plus the linked server used for the subscriber.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Antares686
Points: 125444
June 14, 2002 at 11:59 am
#430911
Should not be affected unless you log SQLAgent logining in with SA. In that case all jobs should fail.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply