Quackit Logo
SQL Server Home
SQL Server 2000

SQL Server 2008

About SQL Server
SQL Server Editions
SQL Server Management Studio
Create A Database
Create A Table
Adding Data
SQL Scripts
Query Designer
SQL Server Views
Stored Procedures
User Logins
Server Roles
Database Schemas
Linked Servers
Integration Services
Summary
FREE Hosting!
With every domain you register with ZappyHost you get FREE hosting.
Create free Flash websites

SQL Server Service Manager

Print Version
Related:
• SQL Server (2008) Tutorial

Note that this tutorial was written for those using the 2000 edition of SQL Server (SQL Server 2000). For later versions of SQL Server, check out the SQL Server 2008 tutorial.

SQL Server Service Manager is used to start, stop, and pause the various components on SQL Server. These components run as Windows services.

The following services can be stopped/started/paused via the SQL Service Manager:

ServiceDescription
SQL Server serviceImplements the SQL Server database engine. There is one SQL Server service for each instance of SQL Server running on the computer.
SQL Server Agent serviceImplements the agent that runs SQL Agent jobs and alerts. There's one SQL Agent service for each instance of SQL Server running on the computer.
Microsoft Search serviceImplements the full-text search engine. There is only one full-text search engine regardless of how many instances of SQL Server are running on the computer.
MSDTC serviceManages distributed transactions. There is only one MSDTC service regardless of how many instances of SQL Server are running on the computer.
MSSQLServerOlAPService serviceImplements the SQL Server Analysis Services. There is only one MSSQLServerOlAPService service regardless of how many instances of SQL Server are running on the computer.

Using the SQL Server Service Manager

SQL Server Service Manager is a taskbar application. When SQL Server Service Manager is minimized, an icon SQL Server Service Manager icon appears in the taskbar.

To use the Service Manager, you can either right click on the icon, or double click on the icon. Right clicking provides a menu of options, double clicking maximizes the Service Manager for you to select your options.

SQL Server Service Manager - maximized

 

Enjoy this website?

  1. Add this page to your Favorites
  2. Link to this page (copy/paste into your own website or blog):
  3. Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!
Need Website Content?
Get unique, quality digital content for your website.
  • 270+ Website Templates
  • 800+ Flash Templates
  • 25,000+ Images, Logos
  • 30,000+ e-Books
  • 15,000+ Scripts
  • 27,000+ Animated GIFs
  • 21,000+ Ringtones
  • ...and much more!
Get your content now!
$1.99 .info domain names!
© Copyright 2000 - 2010 Quackit.com