1 / 16

Chapter Overview

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. New Folders Added. NTFS File Permissions. Shared Registry Keys.

gwylan
Download Presentation

Chapter Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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.

More Related