Skip to content

sql-server-integration-services-properties-service-tab.md

Latest commit

 

History

History
53 lines (39 loc) · 2.52 KB

sql-server-integration-services-properties-service-tab.md

File metadata and controls

53 lines (39 loc) · 2.52 KB
title SQL Server Integration Services Properties (Service Tab)
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology configuration
ms.topic conceptual
ms.assetid 37f0acd9-c96f-48fd-9b53-2ca0097af242
author markingmyname
ms.author maghan
monikerRange >=sql-server-2016||=sqlallproducts-allversions

SQL Server Integration Services Properties (Service Tab)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] Use the Servicetab on the [!INCLUDEssISnoversion] Properties dialog box to view or specify the following options.

Options

Binary Path
Displays 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
The [!INCLUDEmsCoName] Windows error code defining any problems encountered in starting or stopping the service. This property is set to ERROR_SERVICE_SPECIFIC_ERROR (1066) when the error is unique to the service represented by this class, and information about the error is available in the ServiceSpecificExitCode property. The service sets this value to NO_ERROR (0) when running, and again upon normal termination.

Host Name
Displays the name of the computer or cluster running the [!INCLUDEssIS] service.

Name
Indicates the display name of the service.

Process ID
Displays the Windows process ID.

SQL Service Type
Displays the type of service provided to calling processes. [!INCLUDEmsCoName] [!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.