Reviewing Service Management Tools

You can configure the service properties of the Microsoft SQL Server services as well as start, pause, or stop these services using the following tools:

  • SQL Server Management Studio

  • SQL Server Configuration Manager

  • net Commands

  • Services

SQL Server Management Studio

SQL Server Management Studio is an administrative tool in SQL Server that:

  • Allows users to start, stop, or pause SQL Server Analysis Services.

  • Allows users to configure the properties of these services.

  • Is the primary tool used to manage all other aspects of an Analysis Services installation.

With Management Studio, Analysis Services instances can be registered and organized into logical groups. Registering an Analysis Services instance records logon and connection property information (such as the database for the connection) so that you do not have to enter this information each time you connect to an Analysis Services instance.

For more information about how to use Management Studio to manage services, see How to Manage Services Using SQL Server Management Studio.

SQL Server Configuration Manager

SQL Server Configuration Manager is a Microsoft Management Console (MMC) snap-in that allows users to manage any of the SQL Server services from within a single snap-in. For more information about how to use SQL Server Configuration Manager to manage services, see How to Manage Services Using SQL Server Configuration Manager.

net Commands

You can use the appropriate net command from the command prompt to start, stop, or pause a Microsoft Windows service. For more information about how to use the net commands to manage services, see How to Manage Services from the Command Prompt Using net Commands.

Services

Services is an MMC snap-in that makes it possible for users to start, stop, or pause Windows services. The Services snap-in can also be used to configure the properties of Windows services. For more information about how to use the Services snap-in, see the Windows Server documentation.