Security Requirements for Managing Services

Security Requirements for Managing ...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

Security Requirements for Managing Services

To manage the Microsoft SQL Server and SQL Server Agent Services, use either SQL Server Configuration Manager or SQL Server Management Studio. Manage the services on clustered servers with the Cluster Administrator.

To manage the SQL Server service and set the server configuration options, you must be a member of the serveradmin fixed server role or the sysadmin fixed server role. Members of the Windows Administrators group can start and stop services and configure the server options that Windows provides.

Note:
To operate properly, the accounts used for the services must be configured with the correct domain, file system, and registry permissions. For information about the required permissions, see Setting Up Windows Service Accounts.

Windows Management Instrumentation

SQL Server Configuration Manager and SQL Server Management Studio use Windows Management Instrumentation (WMI) to display and modify some of the server properties. To manage services and obtain the status of the services, the user must have rights to access the WMI object. In SQL Server Management Studio, the following server property pages use WMI:

Autostart Services
Startup Parameters
Security
Misc Server Settings

Tasks

Concepts

Other Resources

Help and Information