Post reply

Changing account passwords

  • October 12, 2006 at 2:53 am

    #67943

    Hi,

    I am planning to change the slqservice and agent passwords on our environment.

    The account is a domain account.

    I'm assuming I just change the domain password and then update the account passwords in sql.

    Has anyone had any problems with this ?

    Regards...Graeme

  • October 12, 2006 at 5:08 am

    #665429

    Graeme,

    That should be fine, make sure you don't change any account information from the Services MMC snap-in, that causes problems, always use EM.

    ll

  • October 12, 2006 at 8:04 am

    #665502

    I agree with lholman, EM is the way to make this change.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • October 13, 2006 at 3:13 pm

    #665848

    Why are you changing them ? The reason I ask is that if you deny 'interactive login' to those accounts through Active Directory and the passwords are both 'complex' and 'secure', you really do not need to change them. They are only good for starting/stopping SQL Server is set up correctly.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • October 14, 2006 at 9:09 pm

    #665900

    You got to be careful if you have any DTS packages saved with passwords.

  • October 17, 2006 at 1:07 am

    #666122

    Thanks very much for all your input.

    I thought it might be quite straightforward..it's just good to get the nod from those who know

    Thanks again

    Graeme

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply