Post reply

SQL Server Service Account in Cluster enviroment

  • June 6, 2008 at 8:31 am

    #192021

    I want to change sql server service account in cluster enviroment (SQL Server 2000 server), what article do I follow?

    the current sql server service account is member of domain admin and I would like to use domain account which is not memeber of domain admin. By changing this from Ent Manager takes care of all the required rights but I am not sure on how it with cluster sql server, will this require to stop and restart sql server services?

  • June 7, 2008 at 5:15 pm

    #825841

    I don't know the answer to your question, but I am almost sure that to be able to use the new account for the SQL service you will have to restart the service. Otherwise the change will not take effect.



    My blog

  • June 7, 2008 at 5:41 pm

    #825845

    In SQL Server 2000, it is strongly recommended you use Enterprise Manager. So, yes, that's the correct way to do so. The reason is that Enterprise Manager will ensure the service account is changed on all the physical servers that can host the SQL Server.

    As far as when it will take effect, yes, the SQL Server service will need to be restarted. Even if you are prompted by Enterprise Manager, use Cluster Administrator to bring the SQL Server resource offline and then bring it and its dependent services back online. The way I usually do this is I bring just the SQL Server service offline (which will cause SQL Server Agent and SQL Server Fulltext to go offline as well). Then to bring them all back online, I bring the group back online (because it will show the red X since some of its resources are offline when you bring SQL Server down). This will automatically bring all the services up in turn.

    K. Brian Kelley
    @kbriankelley

  • June 7, 2008 at 6:06 pm

    #825847

    Brian, thanks for the explanation!



    My blog

  • June 9, 2008 at 7:32 am

    #826086

    K. Brian Kelley (6/7/2008)

    In SQL Server 2000, it is strongly recommended you use Enterprise Manager. So, yes, that's the correct way to do so. The reason is that Enterprise Manager will ensure the service account is changed on all the physical servers that can host the SQL Server.

    As far as when it will take effect, yes, the SQL Server service will need to be restarted. Even if you are prompted by Enterprise Manager, use Cluster Administrator to bring the SQL Server resource offline and then bring it and its dependent services back online. The way I usually do this is I bring just the SQL Server service offline (which will cause SQL Server Agent and SQL Server Fulltext to go offline as well). Then to bring them all back online, I bring the group back online (because it will show the red X since some of its resources are offline when you bring SQL Server down). This will automatically bring all the services up in turn.

    Thanks for the step by step process.

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

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