SQL Server Performance

Changing Service Account Password

Discussion in 'SQL Server 2005 Clustering' started by Balasundaram, Apr 25, 2007.

  1. Balasundaram New Member

    I want to change the service account password(forgotten) and the sql server is clustered.

    What are the necessary steps to be taken before doing this task.

    Thanks,
    Bala
  2. techbabu303 New Member

    I remember doing this as a offline operation....wait for GURUS responses on this.

    Cheers
    Satish
  3. satya Moderator

  4. Balasundaram New Member

    Hi Satya,

    I just need to change the pwd not the service account(login) itself.

    I think I can inform the window admin team to change the pwd in the active directory, once they change they will let me know the pwd which I need to update in the sql service account.

    Now the sql server(clustered) is up and running. Once I get the new pwd, can i just simply apply the new pwd in the sql service account?

    Any other steps which i need to follow when the sql is clustered?

    Thanks,
    Bala

  5. satya Moderator

    Nothing specific just follow the KBAs above. During the transition of password change ensure to stop the SQL services to avoid any sort of failures.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page