| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Security Requirements for Managing Services |
Learn about security measures that apply to managing SQL Server services. See what roles, group memberships, and permissions you need for configuration access. |
rwestMSFT |
randolphwest |
03/14/2017 |
sql |
configuration |
conceptual |
|
[!INCLUDE SQL Server] To manage the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] and [!INCLUDEssNoVersion] Agent Services, use either SQL Server Configuration Manager or [!INCLUDEssManStudioFull]. Manage the services on clustered servers with the Cluster Administrator.
To manage the [!INCLUDEssNoVersion] 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 Configure Windows Service Accounts and Permissions.
SQL Server Configuration Manager and [!INCLUDEssManStudioFull] 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 [!INCLUDEssManStudioFull], the following server property pages use WMI:
-
Autostart Services
-
Startup Parameters
-
Security
-
Misc Server Settings