Table of contents
- Overview of Installing SQL Server 2000
-
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
- Network Libraries
- Services Accounts
- Authentication Mode
- Choose Licensing Mode
- Installing a Remote Configuration
- Advanced Installation Options
- Working with Named and Multiple Instances of SQL Server 2000
- Working with Instances and Versions of SQL Server
- Failover Clustering
-
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
-
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
-
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)
-
How to Install SQL Server 2000
-
Related Topics
-
Database Architecture
- Logical Database Components
-
Relational Database Components
- Database Applications and Servers
- Logins
- Client Components
- Communication Components
- Server Components
- 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)
-
Managing Clients
- Using the Copy Database Wizard
-
Managing Security
- Security Architecture
- Planning Security
- Security Levels
- Creating Security Accounts
- Managing Security Accounts
- Managing Permissions
- Advanced Security Topics
- Auditing SQL Server Activity
-
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)
-
Managing Security
-
Database Architecture
- Installing Analysis Services
- Microsoft SQL Server 2000 Copyright and Disclaimer
- Additional SQL Server Resources