Surface Area Configuration for Services and Connections (Service) - SQL Server Browser

The SQL Server Browser service returns named pipe and TCP port information to client applications. Enabling this service is useful when a pipe name or port number of a named instance is unknown to client applications. If you disable this service, you may choose static ports for Database Engine named instances and then specify the port number in client connections. For Analysis Services named instances, it is best to enable the SQL Server Browser service.

Options

  • Service name
    The name of the service.
  • Display name
    The name that appears in the Name column in the Windows Services panel.
  • Description
    The service description, which also appears in the Description column of the Microsoft Windows services panel.
  • Startup type
    Use to configure how the service starts.

    Automatic specifies that the service starts when the system starts.

    Manual specifies that a user or dependent service can start the service, and that the service does not start when the system starts.

    Disabled prevents the service from being started by the system, a user, or any dependent service.

  • Service status
    Shows the status of the service.
  • Start button
    Starts the service.
  • Stop button
    Stops the service.
  • Pause button
    Pauses the service.
  • Resume button
    Resumes the paused service.

See Also

Concepts

Surface Area Configuration for Services and Connections
Surface Area Configuration for Features

Help and Information

Getting SQL Server 2005 Assistance