[SQL Server] How to change the SQL Server and Agent SQL service account

BLOG

7/1/20241 min lire

To change a SQL service startup account, you need to use the SQL Server Configuration Manager and then clic on the SQL Server service > Properties

You should be aware that a restart is required.

The chosen account should preferably be a domain account with local administrator privileges.

Failing that, it must have the following permissions :

  • Log on as a service

  • Replace a process-level token

  • Bypass traverse checking

  • Adjust memory quotas for a process

You must also ensure that the account has sufficient rights on the database directories.