Skip to content

manage-the-database-engine-services.md

Latest commit

 

History

History
101 lines (70 loc) · 8.45 KB

manage-the-database-engine-services.md

File metadata and controls

101 lines (70 loc) · 8.45 KB
title Manage the Database Engine Services
description Get acquainted with services that are available in SQL Server. See how to start SQL Server Configuration Manager, which you can use to manage various services.
author rwestMSFT
ms.author randolphwest
ms.date 03/14/2017
ms.prod sql
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
SQL Server Configuration Manager, accessing
Database Engine [SQL Server], services
managing services [SQL Server], about service management
services [SQL Server]
SQL Server Agent service, managing
SQL Server services, about SQL Server service
MSSQLServer
server configuration [SQL Server]
managing services [SQL Server]
SQL Server Agent service
services [SQL Server], managing
administering SQL Server, services
SQL Server services

Manage the Database Engine Services

[!INCLUDE SQL Server] [!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 provides 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.

Using the SQL Server Service

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.

Using SQL Server Configuration Manager

[!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.

In this Section

:::row::: :::column::: Security Requirements for Managing Services

    [Configure Windows Service Accounts and Permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md)

    [Configure File System Permissions for Database Engine Access](../../database-engine/configure-windows/configure-file-system-permissions-for-database-engine-access.md)

    [Run SQL Server With or Without a Network](../../database-engine/configure-windows/run-sql-server-with-or-without-a-network.md)

    [SQL Server Browser Service &#40;Database Engine and SSAS&#41;](../../database-engine/configure-windows/sql-server-browser-service-database-engine-and-ssas.md)

    [Database Engine Service Startup Options](../../database-engine/configure-windows/database-engine-service-startup-options.md)

    [Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service](../../database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services.md)

    [Start SQL Server in Single-User Mode](../../database-engine/configure-windows/start-sql-server-in-single-user-mode.md)

    [Start SQL Server with Minimal Configuration](../../database-engine/configure-windows/start-sql-server-with-minimal-configuration.md)
:::column-end:::
:::column:::
    [Connect to Another Computer &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-connect-to-another-computer.md)

    [Set an Instance of SQL Server to Start Automatically &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-set-an-instance-to-start-automatically.md)

    [Prevent Automatic Startup of an Instance of SQL Server &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-prevent-automatic-startup-of-an-instance.md)

    [Change the Service Startup Account for SQL Server &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-change-the-service-startup-account.md)

    [Configure Server Startup Options &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-configure-server-startup-options.md)

    [Change the Password of the Accounts Used by SQL Server &#40;SQL Server Configuration Manager&#41;](../../database-engine/configure-windows/scm-services-change-the-password-of-the-accounts-used.md)

    [Configure SQL Server Error Logs](../../database-engine/configure-windows/scm-services-configure-sql-server-error-logs.md)
:::column-end:::
:::column:::
    [Change Server Authentication Mode](../../database-engine/configure-windows/change-server-authentication-mode.md)

    [SQL Writer Service](../../database-engine/configure-windows/sql-writer-service.md)

    [Broadcast a Shutdown Message &#40;Command Prompt&#41;](../../database-engine/configure-windows/broadcast-a-shutdown-message-command-prompt.md)

    [Log In to an Instance of SQL Server &#40;Command Prompt&#41;](../../database-engine/configure-windows/log-in-to-an-instance-of-sql-server-command-prompt.md)
:::column-end:::

:::row-end:::

Related Content

Configure SQL Server Agent

Logging In to SQL Server