Export (0) Print
Expand All

Features of SQL Server 2000 (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

During setup of Microsoft® SQL Server™ 2000 (64-bit), you can choose features and subfeatures to install, to remove, or to add if not included in an initial installation of SQL Server. Before you begin the Setup Wizard, familiarize yourself with the different features and decide which ones are appropriate for your installation.

Choosing Features and Options to Install

SQL Server can be used in a number of different contexts; not all features and options of SQL Server are needed for every installation. You may have a database server, an Internet server, or require a database on a client computer. If you are running database client/server applications you may or may not require a database on your computer. You may need tools to administer a database server, or you may want to run applications that access an instance of SQL Server. You may want an Analysis server for online analytical processing (OLAP) and data mining. Installation choices for these and other SQL Server configurations are described in the following paragraphs.

Installing SQL Server on a Database Server

If you are creating a database server, install SQL Server 2000 (64-bit) Enterprise Edition. On a 64-bit database server, you can install a default instance of the SQL Server 2000 (64-bit) relational database engine. You can also install one or more named instances of the SQL Server 2000 (64-bit) relational database engine. Other than specifying an instance name, the setup choices for installing a named instance are similar to those for installing a default instance.

Using SQL Server with an Internet Server

On an Internet server, such as a server running Microsoft Internet Information Services (IIS), you typically install the SQL Server 2000 Management Tools. SQL Server 2000 (64-bit) does not include graphical tools (other than the Server Network Utility and the Service Manager), but it does support the same command-line tools that are supported by the 32-bit version of SQL Server 2000. These include the client connectivity features used by an application connecting to an instance of SQL Server. In addition, the client tools include the utility for configuring the virtual roots needed for applications to access SQL Server through URLs.

After installing the SQL Server tools, configure the virtual roots that support accessing an instance of SQL Server through a URL. For more information about configuring the virtual roots, see the "Using IIS Virtual Directory Management for SQL Server Utility" topic (64-bit) in the SQL Server 2000 32-bit Books Online.

Note  Although you can install an instance of SQL Server on a computer running IIS, this is typically not recommended and may be done only for small Web sites that have a single server computer. Most Web sites have their middle-tier IIS system on one server or cluster of servers, and their databases on a separate server or federation of servers. For more information about federations, see the "Federated SQL Server 2000 Servers" topic in SQL Server 2000 32-bit Books Online.

Installing Analysis Services

If you require an Analysis server for online analytical processing (OLAP) and data mining, install Analysis Services. You can choose to install Analysis Server, which comes with SQL Server. The SQL Server 2000 (64-bit) Analysis Services uses a SQL Server repository, so Setup always installs Analysis Services with an instance of SQL Server including the core SQL Server program files, even if you choose not to install the SQL Server database components. If you want SQL Server and Analysis server on the same computer, but sharing different core database server files, then install them separately in separate instances.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft