172 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
Applying Microsoft SQL 2000 Server Service Pack 2
The following procedure upgrades Microsoft SQL Server to Service Pack 2 level.
1. Log on to SQL Database Server as Administrator.
2. Run setupsql.exe from the Service Pack 2 directory, usually in
<mssql>x86setup
3. The Microsoft SQL Server Service Pack 2 setup dialog starts with the
InstallShield Welcome dialog.
4. Follow the instructions in the dialog boxes. Accept the default settings and
values throughout the installation.
5. Click OK on the message You should now backup your master and msdb
databases since this installation has updated their content.
6. When the Setup Complete dialog opens, select Yes, I want to restart my
computer now. Click Finish to conclude the upgrade.
7. The server will reboot now automatically.
Updating SQL Server Client-Side Options
To function correctly, IBM Tivoli Business Systems Manager requires changes to
certain SQL Server client-side options, such as the ANSI NULL, paddings, and
warnings. The following steps disable these options:
1. Open the SQL Query Analyzer from the Windows Start menu by selecting
Programs -> Microsoft SQL Server -> Query Analyzer. This opens the
Connect to SQL Server dialog as shown in Figure 6-21 on page 173.
Attention: Refer to pages 58 and 59 of the
IBM Tivoli Business Systems
Manager: Installation and Configuration Guide
, GC32-0800 document
regarding a potential problem with sp2_serv_uni.sql file. This modification, if
applicable, must be made before Service Pack 2 can be applied.