SQLConfiguration SQLConfiguration


SQL Server  «Prev 

SQL Server 2005 Services in the running state

The following images illustrate the four SQL Server services in the Running state using Windows.

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


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.
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.
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.

SQL ServerAgent service in the Running State

MS SQL Server service in the Running state.

MSDTC service in the Running state.