| title | Manage the Database Engine Services | Microsoft Docs | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||||||
| ms.date | 03/14/2017 | |||||||||||||
| ms.prod | sql | |||||||||||||
| ms.prod_service | database-engine | |||||||||||||
| ms.service | ||||||||||||||
| ms.component | configure-windows | |||||||||||||
| ms.reviewer | ||||||||||||||
| ms.suite | sql | |||||||||||||
| ms.technology |
|
|||||||||||||
| ms.tgt_pltfrm | ||||||||||||||
| ms.topic | article | |||||||||||||
| helpviewer_keywords |
|
|||||||||||||
| ms.assetid | aa732e43-53ba-4eea-bb9b-089da0766fc1 | |||||||||||||
| caps.latest.revision | 43 | |||||||||||||
| author | MikeRayMSFT | |||||||||||||
| ms.author | mikeray | |||||||||||||
| manager | craigg | |||||||||||||
| ms.workload | On Demand |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] [!INCLUDEmsCoName] [!INCLUDEssNoVersion] runs on the operating systems as a service. A service is a type of application that runs in the system background. Services usually provide core operating system features, such as Web serving, event logging, or file serving. Services can run without showing a user interface on the computer desktop. The [!INCLUDEssDEnoversion], [!INCLUDEssNoVersion] Agent, and several other [!INCLUDEssNoVersion] components run as services. These services typically are started when the operating system starts. This depends on what is specified during setup; some services are not started by default. This section describes the management of the various [!INCLUDEssNoVersion] services. Before you log in to an instance of [!INCLUDEssNoVersion], you need to know how to start, stop, pause, resume, and restart an instance of [!INCLUDEssNoVersion]. After you are logged in, you can perform tasks such as administering the server or querying a database.
When you start an instance of [!INCLUDEssDEnoversion], you are starting the [!INCLUDEssNoVersion] service. After you start the [!INCLUDEssNoVersion] service, users can establish new connections to the server. The [!INCLUDEssNoVersion] service can be started and stopped as a service, either locally or remotely. The [!INCLUDEssNoVersion] service is referred to as [!INCLUDEssNoVersion] (MSSQLSERVER) if it is the default instance, or MSSQL$*<instancename>*if it is a named instance.
[!INCLUDEssNoVersion] Configuration Manager allows you to stop, start, or pause various [!INCLUDEssNoVersion] services.
Note
[!INCLUDEssNoVersion] Configuration Manager cannot manage [!INCLUDEssVersion2000] services.
You can also use [!INCLUDEssNoVersion] Configuration Manager to view the properties of the selected service. [!INCLUDEssNoVersion] Configuration Manager is a [!INCLUDEmsCoName] Management Console (MMC) snap-in. For more information about MMC and how a snap-in works, see Windows Help.
To access SQL Server Configuration Manager
- On the Start menu, point to All Programs, point to [!INCLUDEssCurrentUI], point to Configuration Tools, and then click SQL Server Configuration Manager.
To access SQL Server Configuration Manager Using Windows 8
Because [!INCLUDEssNoVersion] Configuration Manager is a snap-in for the [!INCLUDEmsCoName] Management Console program and not a stand-alone program, [!INCLUDEssNoVersion] Configuration Manager not does not appear as an application when running Windows 8.0. To open [!INCLUDEssNoVersion] Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc (for [!INCLUDEssSQL14]), SQLServerManager11.msc (for [!INCLUDEssSQL11]), or SQLServerManager10.msc for ([!INCLUDEssKatmai]), and then press Enter.