Password Change SQL SERVER 2008 Cluster

  • Hi Folks,

    I have SQL SERVER 2008 Failover cluster installed.We have the password policy at the windows level.Can any one suggest me in which way we can change the password for the accounts being used in the cluster.(As log on as for the SQL server services.)

  • You should use SQL Configuration Manager and the nodes should be online. SQL Configuration Manager is the only way you should change SQL Server Service Account passwords.



    Ben Miller
    Microsoft Certified Master: SQL Server, SQL MVP
    @DBAduck - http://dbaduck.com

  • Since its the cluster changing on one node will the change reflect the other nodes ?

  • ensure all nodes are online and use SQL Server configuration manager to change the account and\or password. The cluster service should handle the rest.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • looping

    Thanks

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

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