SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Microsoft SQL Server Services Management Guide

gwylan avatar
gwylan
16 diapositives · 306 Views · Sep 25, 2014

This chapter provides an overview of managing Microsoft SQL Server 2000 services. Learn about working with Osql, SQL Query Analyzer, and SQL Server Enterprise Manager. Explore registry keys, permissions, and service configurations in detail.

#microsoft sql server services management guide #microsoft sql server services management guide ppt #powerpoint #presentation
Microsoft SQL Server Services Management Guide - slide 1
01 / 16Microsoft SQL Server Services Management Guide
1 / 17

Télécharger la présentation

Microsoft SQL Server Services Management Guide
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Chapter Overview • Reviewing the Results of Installation • Starting, Stopping, Pausing, and Modifying Microsoft SQL Server 2000 Services • Working with Osql, SQL Query Analyzer, and SQL Server Enterprise Manager

  2. New Folders Added

  3. NTFS File Permissions

  4. Shared Registry Keys • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80 • HKLM\SOFTWARE\Microsoft\MSDTC • HKLM\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper • HKLM\SOFTWARE\Microsoft\MSSQLServer\Client

  5. Registry Keys Unique for Each Instance • Default instance • HKLM\SOFTWARE\Microsoft\MSSQLServer • HKLM\SYSTEM\CurrentControlSet\Services\MSSQLServer • Each named instance • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName • HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$InstanceName

  6. Default Instance Registry Key Access Restrictions • HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer • HKLM\SOFTWARE\Microsoft\MSSQLServer\Providers • HKLM\SOFTWARE\Microsoft\MSSQLServer\Setup • HKLM\SOFTWARE\Microsoft\MSSQLServer\Replication • HKLM\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent • HKLM\SOFTWARE\Microsoft\MSSQLServer\Tracking • HKLM\SYSTEM\CurrentControlSet\Services\MSSQLServer

  7. Named Instance Registry Key Access Restrictions • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName • HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$InstanceName

  8. Access Permissions on Existing Registry Keys • HKLM\SOFTWARE\Clients\Mail • HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

  9. Microsoft SQL Server Program Group

  10. Default Configuration for Each SQL Server Service • SQL Server service: auto start using a domain user account • SQL Server Agent service: manual start using the same domain user account • Microsoft Distributed Transaction Coordinator (MS DTC) service: auto start using the local system account • Microsoft Search service: auto start using the local system account

  11. Stopping, Starting, and Pausing SQL Server Services • SQL Server Service Manager • SQL Query Analyzer and SQL Profiler • SQL Server Enterprise Manager • Microsoft Windows 2000 Services Microsoft Management Console (MMC) or Windows NT Services program • NET command

  12. SQL Server and SQL Server Agent Account Services • When you want to change the service account of these services, you must use SQL Server Enterprise Manager. • SQL Server Enterprise Manager sets the appropriate user privileges and NTFS and Windows registry permissions for the new account. • SQL Server Enterprise Manager registers the services accounts with the Microsoft Search service. • If the SQL Server service is using a non-administrator account, you must specify an administrator account.

  13. Working with Osql • Command-prompt utility for querying SQL Server. • Can be used interactively or to submit batches and jobs. • Uses the Open Database Connectivity (ODBC) API. • Arguments are case-sensitive.

  14. Working with SQL Query Analyzer Figure 3.4

  15. Working with SQL Server Enterprise Manager Figure 3.5

  16. Chapter Summary • The SQL Server Setup program installs SQL files, adds registry keys, and sets permissions. • The SQL Server Service Manager controls SQL Server services. • Osql and SQL Query Analyzer are used for querying SQL Server. • SQL Server Enterprise Manager is used for administering SQL Server.