Overview of Installing SQL Server 2000
Preparing to Install SQL Server 2000
Hardware and Software Requirements for Installing SQL Server 2000
SQL Server 2000: Editions and Components
Installing English Query
Installing Analysis Services
Setting up Windows Services Accounts
File Paths for SQL Server 2000
Upgrading an Existing Installation of SQL Server
Basic Installation Options
Entering Information in Basic Setup Screens
Computer Name
Installation Selection
Existing Installation Options
Installation Definition
User Information
Instance Name
Setup Type: Typical, Minimum, or Custom
Select Components
Server Components
Management Tools
Client Connectivity
Books Online
Development Tools
Code Samples
Network Libraries
Services Accounts
Authentication Mode
Choose Licensing Mode
Installing a Remote Configuration
Remote Setup Information
Advanced Installation Options
Installing a Virtual Server Configuration
Failover Clustering: Defining the Virtual Server
Cluster Management Screen
Cluster Disk Selection Screen
Quorum Disk Selection Warning
Modify Node List Warning
Performing an Unattended Installation
Creating a Setup File Manually
Setup Initialization File Details
Installing SQL Server Using SMS
Rebuilding the Registry
Working with Named and Multiple Instances of SQL Server 2000
Naming Conventions for Instances of SQL Server 2000
Network Protocols for Named Instances
File Locations for Multiple Instances of SQL Server
Removing Multiple Instances of SQL Server 2000
Working with Instances and Versions of SQL Server
Using SQL Server 6.5 with SQL Server 2000
Running SQL Server 7.0 Along with a Named Instance of SQL Server 2000
Working with Three Versions of SQL Server
Failover Clustering
Failover Clustering Support
Creating a Failover Cluster
Failover Clustering Example
Upgrading to a SQL Server 2000 Failover Cluster
Handling a Failover Cluster Installation
Before Installing Failover Clustering
Installing Failover Clustering
Failover Clustering Dependencies
Maintaining a Failover Cluster
Using SQL Server Tools with Failover Clustering
Failover Cluster Troubleshooting
How To Install Failover Clustering
How to create a new failover cluster (Setup)
How to install a one-node failover cluster (Setup)
How to add nodes to an existing virtual server (Setup)
How to remove a node from an existing failover cluster (Setup)
How to remove a failover clustered instance (Setup)
How to recover from failover cluster failure in Scenario 1
How to recover from failover cluster failure in Scenario 2
How to upgrade from a SQL Server 6.5 active/passive failover cluster (Setup)
How to upgrade from a SQL Server 6.5 active/active failover cluster (Setup)
How to upgrade from a SQL Server 7.0 active/active failover cluster (Setup)
How to upgrade from a SQL Server 7.0 active/passive failover cluster (Setup)
How to upgrade from a default instance to a default clustered instance of SQL Server 2000 (Setup)
How to upgrade from a local default instance to a clustered, named instance of SQL Server 2000 (Setup)
Collation Options for International Support
Collation Settings in Setup
Windows Collation Sorting Styles
Windows Collation Designators
Using SQL Collations
Examples of SQL Collations
Selecting a SQL Collation
Setting Client Code Pages
Upgrading Character Set, Sort Order, and Collation
Changing Collation Settings After Installing
After Installing or Upgrading to SQL Server 2000
Using the Start Menu
System and Sample Databases
Locating Directories and Files
Changing Passwords and User Accounts
Renaming a Server
Deploying SQL Server After Initial Installation
Installing Full-Text Search and Indexing Tools
Configuring SQL Server 2000 After Upgrading
Switching Between SQL Server 6.5 and SQL Server 2000
Removing SQL Server 7.0 or SQL Server 6.5 After Upgrading
Removing SQL Server 2000
Upgrading to SQL Server 2000: Overview
Hardware and Software Requirements for Upgrading
Upgrading from SQL Server 7.0 to SQL Server 2000
Replication and Upgrading
Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)
Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)
Preparing to Upgrade from SQL Server 6.5
Estimating the Disk Space Required for Upgrading
Data and Object Transfer
Order of Upgrade Using a Direct Pipeline or Tape Drive
Upgrading Using One or Two Computers (Logon Screen)
Selecting a Scripting Code Page
Selecting Databases to Upgrade
Database Configuration
Proposed Database Layout
Tape Upgrade Transfer Options
System Configuration
Completing the SQL Server Upgrade Wizard
Upgrade Script Interpreter
Backward Compatibility
SQL Server 2000 and SQL Server version 7.0
SQL Server 2000 and SQL Server version 6.5
SQL Server Backward Compatibility Details
SetHostName property not used in SQL Server 2000
Level 1: Handling Discontinued Functionality
Level 2: Handling Major Changes to Behavior
Level 3: Updating to Improve Earlier Functionality
Level 4: Handling Minor Changes to Behavior
How to Install
How to Install SQL Server 2000
How to install SQL Server 2000 (Setup)
How to install client tools only (Setup)
How to install tools only from any compact disc (Setup)
How to install connectivity only (Setup)
How to install a named instance of SQL Server 2000 (Setup)
How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)
How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)
How to perform an edition upgrade within SQL Server 2000 (Setup)
How to uninstall an existing installation of SQL Server (Setup)
How to test an installation of SQL Server 2000 (Command Prompt)
How to change SQL Server services login account information (Windows NT)
How to change SQL Server services login account information (Windows)
How to change SQL Server services login account information (Enterprise Manager)
How to rebuild the registry (Setup)
How to rebuild the master database (Rebuild Master utility)
How to perform a remote installation of SQL Server 2000 (Setup)
How to record an unattended installation file (Setup)
How to run an unattended installation of SQL Server 2000 (Command Prompt)
How to add components to an instance of SQL Server 2000 (Setup)
How to access SQL Server Books Online for SQL Server 7.0
How to install English Query (Setup)
How to install Analysis Services (Setup)
How to create a case-sensitive instance of SQL Server 2000 (Setup)
How to set client code pages
How to switch from SQL Server 6.5 to SQL Server 2000 (Command Prompt)
How to switch from SQL Server 6.5 to SQL Server 2000 (Windows)
How to remove SQL Server 2000 (Windows)
How To Upgrade from SQL Server 6.5
How to change the size of tempdb in SQL Server 6.5 (ISQL/w)
How to change to the current server name in the SQL Server 6.5 master database (ISQL/w)
How to update the device file locations in the SQL Server 6.5 master database (ISQL/w)
How to estimate the disk space required for an upgrade from SQL Server version 6.5 to SQL Server 2000 (SQL Server Upgrade Wizard)
How to edit the default database configuration (SQL Server Upgrade Wizard)
How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a direct pipeline (SQL Server Upgrade Wizard)
How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a tape drive (SQL Server Upgrade Wizard)
Related Topics
Database Architecture
Logical Database Components
Data Types and Table Structures
SQL Views
SQL Stored Procedures
SQL User-Defined Functions
Constraints, Rules, Defaults, and Triggers
Constraints
Rules
Defaults
Triggers
Collations
SQL Server Collation Fundamentals
Selecting Collations
Specifying Collations
Specifying the Default Collation for an Instance of SQL Server
Mixed Collation Environments
Changing Collations
SQL Indexes
Table Indexes
View Indexes
Maximum Size of Index Keys
Property Management
Full-Text Catalogs and Indexes
Logins, Users, Roles, and Groups
Logins
Users
Roles
Groups
Owners and Permissions
Session Context Information
Relational Database Components
Database Applications and Servers
Logins
Client Components
Communication Components
Client and Server Net-Libraries
Controlling Net-Libraries and Communications Addresses
Tabular Data Stream Protocol
Net-Library Encryption
Server Components
SQL Server Service
SQL Server Agent Service
Microsoft Search Service
MSSQLServerADHelper Service
MS DTC Service
Multiple Instances of SQL Server
Communicating with Multiple Instances
Using Multiple Instances
Working with Multiple Instances
Federated SQL Server 2000 Servers
Partitioning Data
Failover Clustering Architecture
SQL Server 2000 Failover Clusters
Active Directory Integration
SQL Server and XML Support
Managing Clients
Managing Clients
How to start the Client Network Utility (Windows)
How to display the network library version numbers (Client Network Utility)
How to set DB-Library conversion preferences (Client Network Utility)
How to add a network library configuration (Client Network Utility)
How to edit a network library configuration (Client Network Utility)
How to delete a network library configuration (Client Network Utility)
How to alias a client to an alternate pipe (Client Network Utility)
How to configure a client to use the Multiprotocol Net-Library (Client Network Utility)
How to configure a client to use TCP/IP (Client Network Utility)
How to configure a client to use the NWLink IPX/SPX network library (Client Network Utility)
How to configure a client to use the AppleTalk network library (Client Network Utility)
How to configure a client to use the Banyan VINES network library (Client Network Utility)
How to configure a client to use the VIA network library (Client Network Utility)
How to configure a client to use a nonstandard network library (Client Network Utility)
How to verify that SQL Server is listening on AppleTalk and can accept a client connection (Client Network Utility)
How to check the ODBC SQL Server driver version (Windows)
Using the Copy Database Wizard
Managing Security
Security Architecture
Planning Security
Single Person Security Example
Small Company Security Example
Corporate Environment Security Example
Security Levels
Authentication Modes
Security Account Delegation
Permissions Validation
Hierarchical Security
Creating Security Accounts
Security Rules
Adding a Windows User or Group
Granting a Windows User or Group Access to a Database
Adding a SQL Server Login
System Administrator (sa) Login
Granting a SQL Server Login Access to a Database
Database Owner (dbo)
Database Object Owner
guest User
Creating User-Defined SQL Server Database Roles
Adding a Member to a SQL Server Database Role
Adding a Member to a Predefined Role
public Role
Using the Create Login Wizard
Managing Security Accounts
Viewing Logins
Modifying Logins
Removing Logins and Users
Denying Login Access to Windows Accounts
Viewing Roles
Viewing and Modifying Role Memberships
Removing a SQL Server Database Role
Viewing Database Users
Managing Permissions
Granting Permissions
Denying Permissions
Revoking Permissions
Resolving Permission Conflicts
Permissions for User-Defined Functions
Using Ownership Chains
Using Views as Security Mechanisms
Using Stored Procedures as Security Mechanisms
Advanced Security Topics
Establishing Application Security and Application Roles
Allowing Other Accounts to Grant Object Permissions
Creating SQL Server File Permissions
Using Encryption Methods
Revealing SQL Server on a Network
Scripting Data Access Controls in Internet Explorer
Auditing SQL Server Activity
Using Audit Logs
C2 Auditing
Procedures
Managing Security
How to set up Windows Authentication Mode security (Enterprise Manager)
How to set up Mixed Mode security (Enterprise Manager)
How to grant a Windows user or group login access to SQL Server (Enterprise Manager)
How to grant a Windows user or group access to a database (Enterprise Manager)
How to add a SQL Server login (Enterprise Manager)
How to add a linked server login (Enterprise Manager)
How to grant a SQL Server login access to a database (Enterprise Manager)
How to create a SQL Server database role (Enterprise Manager)
How to add a member to a SQL Server database role (Enterprise Manager)
How to add a member to a fixed server role (Enterprise Manager)
How to grant SQL Server login access to a user by using the Create Login Wizard (Enterprise Manager)
How to view a SQL Server login or Windows user or group (Enterprise Manager)
How to view a database user (Enterprise Manager)
How to change the password of a SQL Server login (Enterprise Manager)
How to change the default database of a login (Enterprise Manager)
How to change the default language of a login (Enterprise Manager)
How to remove a user or group from a database (Enterprise Manager)
How to remove a SQL Server login (Enterprise Manager)
How to revoke a Windows user or group login access from SQL Server (Enterprise Manager)
How to deny login access to a Windows user or group (Enterprise Manager)
How to remove a linked server login (Enterprise Manager)
How to view the roles defined in the current database (Enterprise Manager)
How to view the fixed server roles (Enterprise Manager)
How to view the members of a database role (Enterprise Manager)
How to remove a user account from a database role (Enterprise Manager)
How to view the members of a fixed server role (Enterprise Manager)
How to remove a login from a fixed server role (Enterprise Manager)
How to remove a SQL Server role (Enterprise Manager)
How to allow access by granting permissions (Enterprise Manager)
How to grant statement permissions to users within a database (Enterprise Manager)
How to grant permissions on multiple objects to a user, group, or role (Enterprise Manager)
How to prevent access by denying permissions (Enterprise Manager)
How to deny statement permissions from users within a database (Enterprise Manager)
How to deny permissions on multiple objects to a user, group, or role (Enterprise Manager)
How to revoke permissions on an object (Enterprise Manager)
How to revoke statement permissions from users in a database (Enterprise Manager)
How to revoke permissions on multiple objects from a user, group, or role (Enterprise Manager)
How to create an application role (Enterprise Manager)
How to remove an application role (Enterprise Manager)
How to reveal or cancel announcement of SQL Server on a network (Windows)
How to grant, deny, or revoke permissions on multiple objects to a user-defined role (Enterprise Manager)
Other Procedures
How to start the default instance of SQL Server (Service Manager)
How to start a clustered instance of SQL Server (Service Manager)
How to start a named instance of SQL Server (Service Manager)
How to start the default instance of SQL Server (Windows)
How to start a named instance of SQL Server (Windows)
How to start the default instance of SQL Server (Command Prompt)
How to start a named instance of SQL Server (Command Prompt)
How to start the default instance of SQL Server in single-user mode (Command Prompt)
How to start a named instance of SQL Server in single-user mode (Command Prompt)
How to start the default instance of SQL Server with minimal configuration (Command Prompt)
How to start a named instance of SQL Server with minimal configuration (Command Prompt)
How to pause and resume the default instance of SQL Server (Service Manager)
How to stop a clustered instance of SQL Server (Service Manager)
How to pause and resume a named instance of SQL Server (Service Manager)
How to pause and resume the default instance of SQL Server (Windows)
How to pause and resume a named instance of SQL Server (Windows)
How to pause and resume the default instance of SQL Server (Command Prompt)
How to pause and resume a named instance of SQL Server (Command Prompt)
How to broadcast a shutdown message (Command Prompt)
How to stop the default instance of SQL Server (Windows)
How to stop a named instance of SQL Server (Windows)
How to stop the default instance of SQL Server (Command Prompt)
How to stop a named instance of SQL Server (Command Prompt)
How to log in to the default instance of SQL Server (Command Prompt)
How to log in to a named instance of SQL Server (Command Prompt)
How to change the default service (Service Manager)
Installing Analysis Services
Hardware and Software Requirements for Installing Analysis Services
Running Setup
Setup Parameters and Silent Installation
Reinstalling Analysis Services
Stopping or Removing Analysis Services
Upgrading from an Earlier Version
Backward Compatibility
7.0 Analysis Services Client and Local Cube Support
Supported Migration Paths for Analysis Services Repositories
Archiving and Restoring Databases Between Versions of Analysis Services
Microsoft SQL Server 2000 Copyright and Disclaimer
Additional SQL Server Resources