How to: Verify Permissions for SQL Server Services

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.

Security Note:
Always run SQL Server services with the least possible privileges.

To verify the permissions for SQL Server services

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.

Security

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

See Also

Reference

Setting Up Windows Service Accounts
Service Account
Service Accounts (Clusters)

Concepts

Security Considerations for a SQL Server Installation

Help and Information

Getting SQL Server 2005 Assistance