Wednesday, March 7, 2012

password for the domain user

My SQL Server is running as a Domain user account and it asked me to enter the password for thr Domain user account when I was changing the Startup account from Local to Domain user.
My QUESTION here is:
Is there a way or command for me to change the password automatically on the Services account, if I change the password for the Domain User account/.None that I know of. I have to track manually wherever I use a domain account, and when I change the password I have to hunt them down and change them (one by one).

-PatP|||you can go directly to the user account in active directory users an computers set the service account's "Password Never Expires" property to true and it will never ask you to change it...

[Windows Support Center (windows Help)]: User and Computer Accounts

Password never expires Prevents a user password from expiring. It is recommended that Service accounts should have this option enabled and should use strong passwords. For more information about strong passwords, see Strong passwords.|||Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way.|||Originally posted by sqlserver2k
Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way. If you find it, please let me know!

-PatP|||wmi scripting will hook you up....

Set objUser = GetObject _
("LDAP://cn=myerken,ou=management,dc=fabrikam,dc=com")
objUser.ChangePassword "i5A2sj*!", "jl3R86df"


you could set this up as an MSX Job
create it run it then delete it

THIS (http://www.microsoft.com/technet/community/scriptcenter/default.mspx) is one of the best site for WMI Admin Scripts

No comments:

Post a Comment