SQL account password - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL account password

Author

Topic

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2007-11-02 : 08:58:15

Hello All,

Is there anyway I would know if the sql accounts used for services did not change their password in last 30 days?

Can I activate any trace which would provide me these details? If yes then what is -ve impact of it on the server?

Thanks,
-P

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-02 : 10:12:44

How to determine when a password was last set: http://www.microsoft.com/technet/scriptcenter/guide/sas_usr_ewhx.mspx?mfr=true
One already scripted: http://www.rlmueller.net/Programs/PwdLastChanged.txt

Future guru in the making.

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2007-11-02 : 12:13:22

Thanks for the reply.

How would be do it in SQL script? Does the system table stores this information in the table? I can not use VB script to do it.

Thanks,
-P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-02 : 23:13:42

Sql service account is windows account, should set password policy in ADS. Sql doesn't store anything of service account.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources