156 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
6.2.6 Microsoft SQL Server
Proceed with this installation only after all other prerequisite software has been
installed and the server has been rebooted successfully.
We are presenting only our experiences from building our system in the lab with
Microsoft SQL 2000 Server Enterprise Edition, which are meant to supplement
the detailed tasks documented in
IBM Tivoli Business Systems Manager:
Installation and Configuration Guide
, GC32-0800. Installations of other types of
SQL servers could also benefit from the information here in addition to the actual
tasks in the installation and configuration guide.
The four steps for installing SQL server must be completed in this sequence:
1. “Microsoft SQL 2000 Server Enterprise Edition installation” on page 156
2. “Changing SQL Server authentication password” on page 169
3. “Applying Microsoft SQL 2000 Server Service Pack 2” on page 172
4. “Updating SQL Server Client-Side Options” on page 172
Microsoft SQL 2000 Server Enterprise Edition installation
Exit all other Windows programs before proceeding with this setup. Do not
re-install SQL server over an installed version. Uninstall the previous version and
reboot the system before continuing with this installation.
It is important to complete all the dialogs as instructed. You can use the Back
button to navigate backward to make any changes during installation, but it is
better to cancel the installation process and re-start it than to try to fix the setup
after an incomplete installation.
These are step-by-step instructions for our SQL server installation:
1. Log on to the SQL database server as Administrator.
2. Run setupsql.exe from the following directory: <drive:mssql>x86setup
3. The setup dialog begins with the InstallShield to guide you through
installation. The welcome dialog is shown in Figure 6-1 on page 157.
Note: <drive:mssql> is the drive letter of the CD-ROM or the path to an
installation directory on a hard drive where the Microsoft SQL 2000 Server
software resides.