How to: Verify Permissions for SQL Server Services

Updated: 5 December 2005

Typically, both SQL Server and SQL Server Agent are assigned the same user account. You can customize the settings for each service during the installation process. For more information about how to customize account information for each service during Setup, see Service Account.,SQL.90).gifSecurity Note:
Always run SQL Server services with the least possible privileges.

  1. Click Start, open Control Panel, and then open Administrative Tools.

  2. Open Local Security Policy, select the Local Policies folder, and then double-click User Rights Assignment.

  3. Right-click a permission, and then select Properties.

  4. In the Properties dialog box, verify that the account for SQL Server Agent is listed. If it is not listed, click Add User or Group, and then add the user account for the SQL Server Agent service.

  5. When the desired changes have been made, click OK.

  6. Repeat the process for each permission and service.

Configure services for SQL Server 2005 so that they function with the minimum required permissions.

Community Additions