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 |
|
nonie2008
Starting Member
6 Posts |
 Posted - 2008-03-11 : 05:04:55
|
| Hi All,we plan to change SA password and there are 2 servers running on replication. what are the precautions that i have to consider?what is the fallback plan should changing SA password causing other error/ bugs?can somebody tell me the exact steps to change SA password for this kind of environment?thanks in advance.-NonieNonie |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-11 : 09:10:50
|
| Is your replication using SA account or SQL Agent service account.? What accounts you used while setting up replication in SQL 2005? |
 |
|
|
nonie2008
Starting Member
6 Posts |
Posted - 2008-03-11 : 22:03:41
|
| Hi there,how do i check both of the items? Thanks-NonieNonie |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-11 : 22:27:48
|
| If you don't put any other account.Replication runs on domian SQL Service account. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 22:59:37
|
| You can check that in publication properties, keep in mind that don't use sa anywhere. |
|
|
|
nonie2008
Starting Member
6 Posts |
Posted - 2008-03-11 : 23:40:25
|
| ok.. will check first and come back to u. anyway, if let it does use SA for replication, should i restart DR server after change SA at production?Nonie |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 23:46:20
|
| Not really. |
|
|
|
|
|
|
Change 'SA' password at sql server