Post reply

how to properly change the service accounts

  • February 25, 2008 at 6:49 am

    #182552

    Hi,

    Could you please inform me

    how to properly change the service accounts for SQL server, SQL server agent and SQL full text search

    Regards,

    Shine

  • February 25, 2008 at 6:56 am

    #781527

    Using the SQL Configuration Manager is the recommended method

    http://support.microsoft.com/kb/283811

    http://support.microsoft.com/kb/911839

    http://technet.microsoft.com/en-us/library/ms143746.aspx

  • February 25, 2008 at 3:53 pm

    #781816

    Best practice is to change all service accounts via the SQL configuration manager. By using the configuration manager you will ensure that the user has all the rights he should. Which are rights to registry values, file paths etc..

    When you install a SQL Server instance, Windows groups are also create. By adding the new login to the Windows group that was created for the current service account, you guarantee that the new account has the same credentials as the previous service account. This is what Configuration Manager does. The group created by default is SQLServer2005MSSQLUser$[your instance]. The same holds true for the other service accounts.


    My blog: http://jahaines.blogspot.com

  • February 27, 2008 at 10:01 am

    #782662

    Use SQL configuration manager to change it. Also check if the user has necessary permissions to start the services and run fine. If possible run the accounts on a domain account rather than a local windows account.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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