Quackit Logo
SQL Server Home

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

Got a MySpace Page?

Get "www.yourname.com" for your MySpace page. Learn how >>.

SQL Server Service Manager

Print Version

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!
 

FREE Hosting!

With every domain name you register with ZappyHost, you get FREE (ad supported) hosting.

PLUS you get:

  • FREE Website Builder
  • FREE Blog
  • FREE Starter Web Page
  • FREE Email Account
  • & much more! (Total value $123 for FREE!)
Get your FREE hosting today! >>
Featured Template:
(Build your websites in minutes!)