The good news is that setting up your SQL Server clients to communicate with the database server is usually easy. The SQL Server installation program can be run on your client machines, and it will install the core data access components along with the SQL Server tools (applications) that you will need.
Before you can install the SQL Server client-management tools and various library files, make sure that the computer meets the following requirements:
After you have established that you meet the minimum requirements, you are ready to start your client installation. You can install the client software in two common ways. The first, and most obvious option, is to run the SQL Server 2000 installation program. This option allows you to install both the client tools and the connectivity software you need.
The installation definition screen that is displayed as part of the SQL Server install allows you to select the components that you would like to install. On this screen, you have the option of installing the Client Tools Only, the Server and Client Tools, or the Connectivity Only (see Figure 9.2). With the Client Tools Only option, you get both the client relational database-management tools and the connectivity components. With the Connectivity Only option, only the relational database client connectivity components are installed. Included in the connectivity components is MDAC 2.6 (Microsoft Data Access Components), which is a requirement for connecting to a SQL Server 2000 named instance. A later version of the MDAC software is installed when SQL Server 2000 service packs are installed.
Figure 9.2. Installation Definition screen.
The other option for installing SQL Server 2000 client software is to utilize the sqlredis program. Sqlredis is a self-extracting executable file that can be launched independently of the SQL Server 2000 installation. It can only be used to install the client connectivity components; the client tools are not part of this install. The sqlredis executable file can be found in several directories on the SQL Server 2000 installation disc, including the ..\STANDARD\x86\other\.
The sqlredis program is often used as part of the setup process for an application that utilizes SQL Server 2000. The installation is silent and installs all of the client connectivity components needed to support a variety of application clients. OLE DB and the ODBC core components, the Microsoft OLE DB provider for SQL Server, the SQL Server ODBC driver, and the default SQL Server client Net-Libraries are all installed with sqlredis.
Microsoft typically releases several service packs for SQL Server. These service packs primarily contain fixes to the initial release of the software or previous service packs. It is a good practice to monitor the release of these service packs and apply them to your SQL Server environment. This includes the deployment of the service packs on your client machines. The service pack installation is very reliable and will ensure that all of the latest connectivity software, including MDAC, is in place.