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 |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2007-09-27 : 01:05:27
|
| Hi, I am using the Windows authentication for SQL Server and SQL Server Agent and the network password changes every 30 days and I manually update the password for SQL Server and Agent. Is there anyway I can update the password programatically?..Thanks,RajuThanks!Rajuhttp://rajusqlblog.blogspot.com/ |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-09-27 : 04:33:46
|
| The easy way is to just use a system account rather then a user, other then that the only way I know how to do it is to write a program to open the properties then change and apply. It will be a lot of api calls though, and a likley pain to do. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-27 : 04:52:29
|
| that sounds pretty inconvenient. the reason the pass changes every 30 days is for security purposes (obviously). I would think that if you had a programatic way to update passwords that that would probably be an even bigger security concern.Most shops make distinctions between user accounts and service accounts. the user accounts expire at some interval (30 days sounds pretty lame to me btw, it should be 4 or 6 months imho). The service accounts don't expire at all. We only change them when someone on our team (who knows the password) leaves the group or the company.I would suggest that you try to get a policy such as that pushed through. It will make your life and the lives of the other syadmins much easier.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 00:08:33
|
| And you can set group policy to disable windows logon for service accounts. |
|
|
|
|
|
|
Changing the Network Password for SQLServer