RE: [Unattended] SQL Server 2000 SP3a

[<Kaa...@ne...>]

> -----Original Message-----
> From: Tony Worrall [mailto:to...@ho...]=20
> Sent: Monday, January 31, 2005 4:23 PM
> To: una...@li...
> Subject: Re: [Unattended] SQL Server 2000 SP3a
>=20
>=20
> I've tried editing the .iss for sp3a with no success, it=20
> seems to hang=20
> halfway through and then complete with a -12 error.=20
>=20
> Perhaps you can send me your .iss file for sp3a to use as a template?=20
> (without the license key, of course!)
<snip>

Here's my working .iss file for sql sp3a, make sure to set the password!

=3D=3D=3D=3D=3D=3DBegin sql2kdef.iss=3D=3D=3D=3D=3D
[InstallShield Silent]
Version=3Dv5.00.000
File=3DResponse File
[File Transfer]
OverwriteReadOnly=3DNoToAll
[DlgOrder]
Dlg0=3DDlgW2kReboot-0
Count=3D16
Dlg1=3DSdWelcome-0
Dlg2=3DDlgMachine-0
Dlg3=3DDlgInstallMode-0
Dlg4=3DSdLicense-0
Dlg5=3DDlgInstanceName-0
Dlg6=3DDlgMaintainInstall-0
Dlg7=3DDlgUpgrade-0
Dlg8=3DServerConnect-0
Dlg9=3DSdBlankPwdWarningDlg-0
Dlg10=3DSdSP3WrngDlg-0
Dlg11=3DSdErrorReportingDlg-0
Dlg12=3DDlgCollation-0
Dlg13=3DDlgServerNetwork-0
Dlg14=3DSdStartCopy-0
Dlg15=3DSdFinish-0
[DlgW2kReboot-0]
Result=3D189
[SdWelcome-0]
Result=3D1
[DlgMachine-0]
Type=3D1
Result=3D1
[DlgInstallMode-0]
Type=3D2
Result=3D1
[SdLicense-0]
Result=3D1
[DlgInstanceName-0]
InstanceName=3DMSSQLSERVER
Result=3D0
[DlgMaintainInstall-0]
Type=3D12
Result=3D1
[DlgUpgrade-0]
Result=3D1
[ServerConnect-0]
NTAuthentication=3D1
SQLAuthentication=3D0
Result=3D1
[SdBlankPwdWarningDlg-0]
AllowBlank=3D0
EnterPwd=3DXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
ConfirmPwd=3DXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Result=3D0
[SdSP3WrngDlg-0]
EnableCrossDBChaining=3D0
UpgradeMSSearch=3D1
MSXTSXUpgraded=3D0
Result=3D1
[SdErrorReportingDlg-0]
EnableErrorReporting=3D0
Result=3D0
[DlgCollation-0]
collation_name=3DSQL_Latin1_General_CP1_CI_AS
Result=3D1
[DlgServerNetwork-0]
NetworkLibs=3D255
TCPPort=3D1433
TCPPrxy=3DDefault
NMPPipeName=3D\\.\pipe\sql\query
Result=3D1
[SdStartCopy-0]
Result=3D1
[Application]
Name=3DMicrosoft SQL Server
Version=3D8.00.000
Company=3DMicrosoft
[SdFinish-0]
Result=3D1
bOpt1=3D0
bOpt2=3D0
=3D=3D=3D=3D=3DEnd sql2kdef.iss=3D=3D=3D=3D=3D