Unattended installation of SP4
-
Can anyone help me on how to create an unattended installation of sp4 to run at midnight. The only time i can deploy sp4 to my production system is at midnight. we have done all our testing and everything is good. now its time to deploy to prd but the time well, i don't wanna wake in the middle of the night to apply sp4. i was hoping i can do an unattended installation. i have already read the info in BOL, after i created my .iss file, the installation still doesn't work. i am hoping someone can help me out here. What am i doing wrong? This is my .iss file information.
[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
Dlg12=DlgServerNetwork-0
Dlg13=SdStartCopy-0
Dlg14=SdFinish-0
[DlgW2kReboot-0]
Result=189
[SdWelcome-0]
Result=1
[DlgMachine-0]
Type=1
Result=1
[DlgInstallMode-0]
Type=2
Result=1
[SdLicense-0]
Result=1
[DlgInstanceName-0]
InstanceName=MyInstNm
Result=0
[DlgMaintainInstall-0]
Type=12
Result=1
[DlgUpgrade-0]
Result=1
[ServerConnect-0]
NTAuthentication=1
SQLAuthentication=0
Result=1
[SdBlankPwdWarningDlg-0]
AllowBlank=0
EnterPwd=' '
ConfirmPwd=' '
Result=0
[SdErrorReportingDlg-0]
EnableErrorReporting=0
Result=0
[DlgCollation-0]
collation_name=SQL_Latin1_General_CP1_CI_AS
Result=1
[DlgServerNetwork-0]
NetworkLibs=###
TCPPort=0
TCPPrxy=Default
NMPPipeName=\\.\pipe\MSSQL$SQL2K\sql\query
Result=1
[SdStartCopy-0]
Result=1
[Application]
Name=Microsoft SQL Server
Version=8.00.000
Company=Microsoft
Lang=0009
[SdFinish-0]
Result=1
bOpt1=0
bOpt2=0
-
This is just an observation, but wouldn't you prefer to be awake and check that the installation was successful and the instances recovered correctly following the server reboot?
There are a lot of changes in SP4, including MDAC.
Regards, Melissa
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply