Change NT service user with domain account

Question

Hi all,
I have a local instance (sql agent, engine and SSIS) on SS 2017 which have been registered without any domain user.
Now, I have these 3 new domain users (ad-hoc for all sql services) I would like to to know what precautions on permissions must I take to allow everything to work.
I would not like to restart the SQL instance and find myself orphaned of some write permissions.

In SQL Server configuration manger I'll change the user of each service.
Thanks, ALEN

Answer 1

That all depends on what permission etc you have granted to the current service accounts and also to the machine account. And here I'm more thinking of Windows permissions than permission in SQL Server.

As for the permissions needed to running SQL Server - no worry, SQL Server Configuration Manager will take care of that. But if you have granted access to the machine account on a file share to permit SQL Server to write backups there or read files for BULK INSERT, you will update those permissions to permit the new service accounts.

In short, you need to have your server(s) documented.