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 |
|
cope
Starting Member
2 Posts |
 Posted - 2009-12-11 : 16:18:18
|
| I am trying to set up a password management system, which will have the ability to change the password for the SA account. I would like to grant the account that this system will be using the ability to change the SA password without knowing the old password because we do not want to have to store the old password anywhere on the system. Is there a permission that I can grant that will grant permissions similar to security admin with the added ability to change the SA password without requiring the old password?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cope
Starting Member
2 Posts |
Posted - 2009-12-14 : 10:26:07
|
| We're trying to avoid granting full SA access to this account. The application we're using for password management doesn't have a copy of the old password so it can only send the new password. We don't want an account that is used strictly for changing passwords to have full blown access to all of our SQL instances. Does anyone have any idea how to achieve this? Thanks! |
 |
|
|
|
|
|
Changing the SA password without the old password