Skip to content

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

Latest commit

 

History

History
46 lines (37 loc) · 3.27 KB

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

File metadata and controls

46 lines (37 loc) · 3.27 KB
title Determine Whether the Database Engine Is Installed and Started | 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
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
SQL Server, determining if installed
verifying Database Engine installation
viewing Database Engine installation
installed Database Engine verification [SQL Server]
ms.assetid babb02e4-3521-4b75-b5df-e09205594375
caps.latest.revision 17
author MikeRayMSFT
ms.author mikeray
manager craigg
ms.workload Active

Determine Whether the Database Engine Is Installed and Started

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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 [!INCLUDEssCurrent] 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.