Share via

SQL Server Cluster with AlwaysOn Availability Groups how to change the service accounts for SQL services?

Jussi Lehti 601 Reputation points
2021-07-13T10:59:49.35+00:00

We are building an Sharepoint 2019 production farm and for the start we have a two-node SQL server cluster with Availability Group configured and apparently someone has installed SQL Server on those nodes with our test-farm SQLAdmin account and also set the SQL Server Services running with test-farm SQLService accounts.

I was able to login to those instances with the test-farm SQLAdmin account and then I just added new login for the prod-farm SQLAdmin with sysadmin rights, but I should also change the service accounts that are running the SQL Server Services to the prod-farm service accounts.

How this should be done in a SQL Server cluster with AvailabilityGroups configured?

This is just the initial setup so any data loss doesn't matter.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,900 questions
Accepted answer
  1. Yi Lu_MSFT 17,471 Reputation points
    2021-07-14T07:34:58.64+00:00

    Hi anonymous user

    Agree with @RobbinVarn-7255, If you are going to change service accounts, here are the steps.

    launch the SQL Configuration Manger.

    Click on the SQL Server Service option and you will see all available services listed on the right-hand side of the window along with their current state, start mode and log on name.

    114514-capture.png

    Right-click on the service and select Properties.

    114446-capture.png

    On the Log On tab you will see the account credentials being used to run the service. You can update this by entering the desired service account name and password into the specified fields.

    114448-capture.png

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jussi Lehti 601 Reputation points
    2021-07-14T07:45:51.617+00:00

    Thanks for both of you!

    I was aware that I need to change it on both nodes from the cfg manager. I was just wondering is there a correct way to do this in an AlwaysOn configuration in a real situation...

    0 comments