Reviewing Service Management Tools
You can configure the service properties of the Microsoft SQL Server 2005 services as well as start, pause, or stop these services using the following tools:
- SQL Server Management Studio
- SQL Server Configuration Manager
- net Commands
SQL Server Management Studio
SQL Server Management Studio is an administrative tool in SQL Server 2005 that:
- Allows users to start, stop, or pause SQL Server 2005 Analysis Services (SSAS).
- 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 2005 services from within a single snap-in. For more information about how to use SQL Server 2005 Configuration Manager to manage services, see How to Manage Services Using SQL Server Configuration Manager.
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 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.