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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-08-23 : 18:32:28
|
| Hi, I want to change the 'sa' pwd for the production system. I have a log shipping job from prod to test server occuring every hr. Right now 'sa' pwd for both servers is same but I would like to keep them different. Though Log shipping requires 'sa' access to work, Will my log shipping be affected in any way? Also, is there any job/maintenance task i need to be aware of? Thanks,Sarat. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-23 : 19:05:15
|
| I don't know much about log shipping, but I can tell you that just because something "needs 'sa' access to work" does not mean that you have to login as 'sa'. This is what the sysadmin server role was designed for, so you could still have a personal login with all the rights of sa. |
 |
|
|
|
|
|
changing 'sa' password