Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: 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/.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    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.

  4. #4
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    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.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

  6. #6
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    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 is one of the best site for WMI Admin Scripts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •