Partilhar via

How to: Start and Stop the SQL Server Browser Service (SQL Server Express)

  • Artigo

In this topic, you will learn how to start and stop the SQL Server Browser service. By default, Microsoft SQL Server 2005 Express Edition (SQL Server Express) does not set the SQL Server Browser service to start automatically.

For more information about using the SQL Server Browser service with SQL Server Express, see Using SQL Server Browser.

To start the SQL Server Browser service

  1. On 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. When the service starts or stops, click OK.

Note

You can also 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 the SQL Server Browser service from the command prompt

  1. On the Start menu, click Run.

  2. In the Run dialog box, type cmd.

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

To stop the SQL Server Browser service from the command prompt

  1. On the Start menu, click Run.

  2. In the Run dialog box, type cmd.

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

See Also

Concepts

Using SQL Server Browser

Help and Information

Getting SQL Server 2005 Assistance