Quackit Logo
SQL Server Home
SQL Server 2008

SQL Server Tutorial

About SQL Server
Enterprise Manager
Create a Database
Create a Table
Adding Data
Query Analyzer
Views
Stored Procedures
SQL Server Security
Create a Login
DTS (Data Transformation Services)
SQL Server Agent
SQL Server Agent Jobs
SQL Server Service Manager
SQL Profiler
SQL Server Summary

FREE Hosting!

With every domain name you register with ZappyHost, you get FREE hosting.

$1.99 Domain Names

With every new non-domain purchase thru ZappyHost, you get a domain name for only $1.99.

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. Link to this page (copy/paste into your own website or blog):
  2. Add this page to your favorite social bookmarks sites:
               
  3. Add this page to your Favorites

Oh, and thank you for supporting Quackit!

Need Content for your Website?

Get unique, quality digital content for your website. You can even earn money by reselling it!

Includes:

  • Over 29,000 Ebooks
  • Over 7,000 Website templates
  • Over 11,000 Fonts
  • Over 39,000 Logos
  • Over 1,000 Cell Phone Games
  • Over 3,000 Cell Phone Images
  • Over 21,000 Ring Tones
  • ...and much more!
Get your 10GB webmaster package now!