| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|
SQL Server Properties (Service Tab) |
Learn about the options on the Service tab of the MSSQLSERVER Properties dialog box, such as the binary path, the host name, and the start mode. |
markingmyname |
maghan |
03/14/2017 |
sql |
tools-other |
conceptual |
>=sql-server-2016 |
[!INCLUDE SQL Server Windows Only] Use the Servicetab on the MSSQLSERVER Properties dialog box to view or specify the following options.
Binary Path
Lists the location of the program files used by this service.
Error Control
1 indicates SERVICE_ERROR_NORMAL. If the service fails to start during computer start up, the startup program logs the error and displays a pop-up message box but continues the startup operation. This value cannot be changed.
Exit Code
When an error occurs, the error number appears in this box. Use this number to troubleshoot failures by searching for the number in the [!INCLUDEmsCoName] Knowledge Base or provide the number to your technical support staff.
Host Name
Displays the name of the computer or cluster running the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] service.
Name
Indicates the display name of the service.
Process ID
Displays the Windows process ID.
Service Type
Displays the type of service provided to calling processes. [!INCLUDEssNoVersion] installs several services.
Start Mode
Set this service to the following choices:
-
Manual: This service does not automatically start when the computer starts. You must start the service using [!INCLUDEssNoVersion] Configuration Manager, or some other tool.
-
Automatic: This service attempts to start when this computer starts.
-
Disabled: This service cannot be started.
State
Indicates whether this service is running, stopped, or disabled. "..." indicates a state change is pending.