Sharepoint 2016 service account change

Question

Some years ago I created this simple architecture:

Virtual machine A: sharepoint 2016 on premises - single server in farm

Virtual machine B: sharepoint database is MS SQL Server (Version 12.0.6433.1)

I created all accounts s with my user - so single user for everything. Sharepoint authenticates from AD.

My problem is that my user will be deleted from AD because I will quit. I guess in this case I need to change all service accounts (and other accounts) to another user. How can I do it? And what to do with the SQL Server?

Thanks in advance,

Ivanhou

Answer 1

First, you need to create at least two domain accounts, one as a farm account and one for other services!

• List all services and application pools that run with your current account.
• Create Domain Accounts in your AD.
• Add the newly created accounts to managed account.
• In SQL Server,
  • the new farm account should have db_creator and SecurityAdmin permission on the server level.
  • The service account should have an owner role on all database services.
• Open Configure service accounts in Central Administration and assign the new service account for the farm account, application pool, services.

• Also, run the below cmdlet to update farm account credentials

  stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword
  

• Run iisreset /noforce to restart IIS

Actually, It's a risky process, so you should apply the above steps on a test environment, and next time you should follow SharePoint Service Accounts Best Practices

Answer 2

Here're steps:

1.Create account in the AD, then add the account to the domain admins group.

2.In the SQL, grant the account as following pictures show.

3.You could change service accounts by using PowerShell.

https://www.sharepointdiary.com/2015/10/change-service-account-in-sharepoint-using-powershell.html