SQL Server Browser Properties (Service Tab)
The SQL Server Browser program runs as a service on the server. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer.
Use the Service tab on the SQL Server Browser Properties dialog box to view the following options. All properties except Start Mode are read-only.
Displays the location of the program files used by this service.
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.
When an error occurs, the error number appears in this box. Use this number to troubleshoot failures by searching for the number in the Microsoft Knowledge Base or provide the number to your technical support staff.
Displays the name of the computer or cluster running the SQL Server Browser service.
Indicates the display name of the service.
Displays the Windows process ID.
Displays the type of service provided to calling processes. SQL Server installs several services.
Set this service to the following choices:
Manual: This service does not 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 cannot be started.
Indicates whether this service is running, stopped, or disabled. "…" indicates a state change is pending.