Skip to content

determine-whether-the-database-engine-is-installed-and-started.md

Latest commit

 

History

History
35 lines (26 loc) · 3.13 KB

determine-whether-the-database-engine-is-installed-and-started.md

File metadata and controls

35 lines (26 loc) · 3.13 KB
title Determine Whether the Database Engine Is Installed and Started
description Learn how to determine whether the Database Engine is installed and started. See how to use SQL Server Configuration Manager to check for installed components.
author rwestMSFT
ms.author randolphwest
ms.date 03/14/2017
ms.service sql
ms.subservice configuration
ms.topic conceptual
helpviewer_keywords
SQL Server, determining if installed
verifying Database Engine installation
viewing Database Engine installation
installed Database Engine verification [SQL Server]

Determine Whether the Database Engine Is Installed and Started

[!INCLUDE SQL Server] A successful installation of the [!INCLUDEssDEnoversion] installs files to the file system, creates entries in the registry, and installs several tools. This topic describes how to determine whether the [!INCLUDEssDE] is installed and started in [!INCLUDEssnoversion] by using [!INCLUDEssNoVersion] Configuration Manager.

Using SQL Server Configuration Manager

How to view and start the Database Engine by using SQL Server Configuration Manager

  1. Click Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

    If you do not have these entries on the Start menu, [!INCLUDEssNoVersion] is not correctly installed. Run Setup to install the [!INCLUDEssDEnoversion].

  2. In SQL Server Configuration Manager, on the left pane, click SQL Server Services. The right pane lists several services that are related to [!INCLUDEssNoVersion]. If the [!INCLUDEssDE] is installed, the [!INCLUDEssDE] service is listed as SQL Server (MSSQLSERVER) if it is the default instance; or SQL Server (<instance_name>), if the [!INCLUDEssDE] is installed as a named instance. Unless the instance name is changed, [!INCLUDEssExpress] installs as a named instance with the name SQLEXPRESS. A green triangle icon indicates that the [!INCLUDEssDE] is running. A red square icon indicates that the [!INCLUDEssDE] is stopped.

  3. To start the [!INCLUDEssDE], in the right pane, right-click the [!INCLUDEssDE], and then click Start.

Note

During setup, the user can select a location in which to install the program files and the database files. If the user accepts the default location, the files are installed to [!INCLUDEssInstallPath] and C:\Program Files\Microsoft SQL Server\MSSQL.x, where x is a number.