3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 4: Upgrade SQL Server Instances 37

NOTE: Be sure to put any virtualized SQL instances into maintenance

mode before attempting to patch the active node. You can patch

any passive backup nodes without putting the Virtual SQL Server

into maintenance mode.

Service Pack Names

The installation procedure expects the names of SQL Server service packs

to follow the standardized naming schema defined in the following

Microsoft Knowledge Base articles:

http://support.microsoft.com/kb/842960

http://support.microsoft.com/kb/822499

The installation will fail if the name of a service pack has been changed

and it no longer matches the appropriate schema.

Create an Answer File for Service Pack 4 Only

With SQL Server 2000 Service Pack 4, Microsoft no longer includes

pre-defined set-up initialization (.iss) files. (These files are also called

answer files.) However, the user is still required to have an answer file for

any unattended installations.

Following is a sample answer file (.iss) for SQL2000 SP4.

[InstallShield Silent]

Version=v5.00.000

File=Response File

[File Transfer]

OverwriteReadOnly=NoToAll

[DlgOrder]

Dlg0=DlgW2kReboot-0

Count=15

Dlg1=SdWelcome-0

Dlg2=DlgMachine-0

Dlg3=DlgInstallMode-0

Dlg4=SdLicense-0

Dlg5=DlgInstanceName-0

Dlg6=DlgMaintainInstall-0

Dlg7=DlgUpgrade-0

Dlg8=ServerConnect-0

Dlg9=SdBlankPwdWarningDlg-0

Dlg10=SdErrorReportingDlg-0

Dlg11=DlgCollation-0