How to: Start and Stop the SQL Server Browser Service

In this topic, you will learn how to start and stop the SQL Server Browser service. By default, Microsoft SQL Server sets the SQL Server Browser service to start automatically.

To start or stop the SQL Server Browser service using SQL Server Configuration Manager

  1. From the Start menu, right-click All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, click SQL Server Services.

  3. In the details pane, right-click SQL Server Browser, and then click Start or Stop.

Note

You can use the properties dialog box to change the Startup Type setting to Manual or Disabled so that the SQL Server Browser service does not start every time the computer starts up.

To start or stop the SQL Server Browser service using Computer Management

  1. From the Start menu, right-click My Computer, and then click Manage.

  2. In Computer Management, expand Services and Applications, and then click Services.

  3. In the list of services, double-click SQL Server Browser.

  4. In the SQL Server Browser Properties window, click Start or Stop.

  5. Once the service starts or stops, click OK.

To start the SQL Server Browser service from a command prompt

  1. From the Start menu, choose Run.

  2. In the Run dialog, type cmd.

  3. From the command prompt, type net start sqlbrowser.

To stop the SQL Server Browser service from a command prompt

  1. From the Start menu, choose Run.

  2. In the Run dialog, type cmd.

  3. From the command prompt, type net stop sqlbrowser.

See Also

Concepts