locked
Renaming the windows SQL cluster startup account RRS feed

  • Question

  • Hi,

    I have a active\passive SQL2005 Cluster setup, the SQL server start up account uses the windows id domain\SQLCLUSTER , now the requirement of the customer is to have this account renamed to domain\ADMINSQLCLUSTER.

    Since this is the SQL server startup account of the cluster setup, what all changes should be done from SQL DBA perspect. Can any of you give me steps to be done or any reference docs\links

    Thanks

    Eben

    Thursday, August 25, 2011 5:43 PM

Answers

  • Nothing special.  You have to make sure the Windows Clustering is running when you make change; or when you bring up the cluster it will revert back to old service account name.  While Windows Cluster is running, bring up SQL Server Configuration Manager.  Update the Service account name and go to Cluster administrator to restart the services.  Pleae make sure the new Sevice account is part of AD groups for Cluster.

    Cheers!


    Mohit K. Gupta --- MCTS, MCITP, MCC2011 http://sqllearnings.blogspot.com/
    • Proposed as answer by Raj Lanka Friday, August 26, 2011 6:00 AM
    • Marked as answer by Peja Tao Monday, August 29, 2011 7:09 AM
    Thursday, August 25, 2011 5:56 PM

All replies

  • Nothing special.  You have to make sure the Windows Clustering is running when you make change; or when you bring up the cluster it will revert back to old service account name.  While Windows Cluster is running, bring up SQL Server Configuration Manager.  Update the Service account name and go to Cluster administrator to restart the services.  Pleae make sure the new Sevice account is part of AD groups for Cluster.

    Cheers!


    Mohit K. Gupta --- MCTS, MCITP, MCC2011 http://sqllearnings.blogspot.com/
    • Proposed as answer by Raj Lanka Friday, August 26, 2011 6:00 AM
    • Marked as answer by Peja Tao Monday, August 29, 2011 7:09 AM
    Thursday, August 25, 2011 5:56 PM
  • Many Thanks Mohit for the suggestion.

     

    Thanks

    Eben

    Friday, August 26, 2011 6:45 AM