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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-10 : 01:18:56
|
| Dear All,presently, i'm working with transactional replication. now i'm changing the password of sa as somany knows the password. will it affect the existing replication?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-10 : 04:20:35
|
| and one more sad thing is the users have permissions to connect through windos authentication mode.....if they changed again the sa password....that will become a big problem. how can i make them to connect only through sql authentication mode?ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-10 : 08:30:02
|
quote:
Originally posted by sunsanvin
Dear All,presently, i'm working with transactional replication. now i'm changing the password of sa as somany knows the password. will it affect the existing replication?ArnavEven you learn 1%, Learn it with 100% confidence.
Thats not good as a senior DBA.Infact windows authentication is better than SQL authentication. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-10 : 08:43:14
|
| how can i restrict them to connect only with the given username?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-10 : 09:03:03
|
| Take away all their other access, BUT, why would you do that. If you are using windows, just set up a windows group and give that the required permissions, then just add their windows logins to that group. |
|
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-07-10 : 09:09:32
|
| If there windows logins have access to change the sa password then they dont need sa, they already have the basicallly same permissions. I agree with RickD, grant only the permission they need."God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 00:36:46
|
| Remove builtin\administrators and other windows groups from sysadmin role. |
|
|
|
|
|
|
|
|
changing password will affect replication?