Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server on Windows
The SQL Server Browser program runs as a service on the server.
SQL Server Browser listens for incoming requests for SQL Server resources and provides information about SQL Server instances installed on the computer.
Use the Service tab on the Properties dialog box to view the following options. All properties except Start Mode are read-only.
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 startup, the startup program logs the error and displays a pop-up message box but continues the startup operation. This value can't be changed.
Exit Code
When an error occurs, the error number appears in this box.
The Windows error code defines 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.
Use this number to troubleshoot failures by searching on Microsoft Learn, or provide the number to your technical support staff.
Host Name
Displays the name of the computer or cluster running SQL Server Browser service.
Name
Indicates the display name of the service.
Process ID
Displays the number used by Windows to keep track of this program's processes.
SQL Service Type
Displays the type of service provided to calling processes. SQL Server installs several services.
Start Mode
Set this service to the following choices:
Manual: This service doesn't automatically start when the computer starts. You must start the service using SQL Server Configuration Manager, or some other tool.
Automatic: This service attempts to start when this computer starts.
Disabled: This service can't be started.
State
Indicates whether this service is running, stopped, or disabled.