Verify user rights assignments to SQL Services account

Verify the user rights assignments for the SQL services account running the SQL Server Database Engine service.

Procedure 

  1. In Windows, go to Control Panel > System and Security > Administrative Tools > Local Security Policy.

  2. In the Local Security Policy window, click Local Policies, and then click User Right Assignment.

    User rights assignment

  3. Double-click each of the following items, and verify that the list includes the service account running the SQL Server Database Engine service:

    1. Lock pages in memory

    2. Log on as a service

    3. Perform volume maintenance tasks

    4. Replace a process-level token

    5. Bypass traverse checking

    The list of privileges changes from time to time. For the most up-to-date list, consult the WFO User Rights, Windows Services, and Settings Guide.

Related information 

SQL Services Account Requirements (Technology, Security, & Network Integration Deployment Reference Guide)

WFO User Rights, Windows Services, and Settings Guide