Chapter Overview

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\MSSQLServe
  rADHelper
• 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\MSSQLInsta
  nceName

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\MSSQLInst
  anceName

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.